Re: Large Join Dies

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