Re: Why do my hash joins turn to nested loops?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-performance(at)ian(dot)org
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Why do my hash joins turn to nested loops?
Date: 2008-08-22 00:49:17
Message-ID: 27300.1219366157@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

pgsql-performance(at)ian(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Decibel! 2008-08-22 04:53:58 Re: Optimizing a VIEW
Previous Message pgsql-performance 2008-08-21 22:50:35 Why do my hash joins turn to nested loops?