El-Lotso <el(dot)lotso(at)gmail(dot)com> writes:
> I'm really at my wits end here.
Try to merge the multiple join keys into one, somehow. I'm not sure why
the planner is overestimating the selectivity of the combined join
conditions, but that's basically where your problem is coming from.
A truly brute-force solution would be "set enable_nestloop = off"
but this is likely to screw performance for other queries.
regards, tom lane
In response to
pgsql-performance by date
|Next:||From: Rafael Barrera Oro||Date: 2007-09-12 18:01:07|
|Subject: Re: random_page_costs - are defaults of 4.0 realistic for
SCSI RAID 1|
|Previous:||From: Nis Jørgensen||Date: 2007-09-12 13:14:25|
|Subject: Re: 500rows = 1min/2.5k rows=20min/6K rows 2 hours and still running|