Re: Why do my hash joins turn to nested loops? - Mailing list pgsql-performance

From Tom Lane
Subject Re: Why do my hash joins turn to nested loops?
Date
Msg-id 27300.1219366157@sss.pgh.pa.us
Whole thread Raw
In response to Why do my hash joins turn to nested loops?  (pgsql-performance@ian.org)
Responses Re: Why do my hash joins turn to nested loops?  (pgsql-performance@ian.org)
List pgsql-performance
pgsql-performance@ian.org writes:
> One query works fast, returning results in under a second.  If I insert
> one more join into the table however, it switches to nested-loops and
> takes minutes.

I think you need to raise from_collapse_limit and/or
join_collapse_limit.

            regards, tom lane

pgsql-performance by date:

Previous
From: pgsql-performance@ian.org
Date:
Subject: Why do my hash joins turn to nested loops?
Next
From: "Kranti K K Parisa™"
Date:
Subject: Re: PostgreSQL+Hibernate Performance