Jeff Madison wrote: > Running Postgres 7.1.4 from RedHad RPM on RedHat 7.2. When ever we run > a query where we are joining more than 3 tables the query never returns. > Any ideas? > > Jeff
Jeff, It would help to know things like: * What the exact query is (and an EXPLAIN of the query) * How big the tables are (and the general schema) * What kind of hardware you're running on Off the top of my head, I would say check your table1.key = table2.key join constraints. More than three tables leads to a lot of constraints and if you miss just one, you'll get a big cartesian product that will make the query seemingly go on forever even if your tables are of moderate size. --Jeremy ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
