On Aug 13, 2012, at 7:11 PM, Tom Lane wrote:
> The whole thing looks a bit weird to me --- why did it not use a
> nestloop join with inner indexscan on charlie? With 7000 rows on the
> other side, the estimated cost for that shouldn't have been more than
> about 30000 ...
Here's the same query with set enable_megejoin = off. All of the other query tuning parameters are default.
-- Christophe Pettus
In response to
pgsql-performance by date
|Next:||From: Tom Lane||Date: 2012-08-15 20:51:12|
|Subject: Re: 7k records into Sort node, 4.5m out?|
|Previous:||From: Doug Hunley||Date: 2012-08-15 13:43:07|
|Subject: Re: cluster on conditional index?|