Thread: Large Join Dies

Large Join Dies

From
"Jeff Madison"
Date:
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


Re: Large Join Dies

From
Jeremy Buchmann
Date:
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