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.
http://explain.depesz.com/s/dqO
--
-- Christophe Pettus
x...@thebuild.com
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
