|
|
| [Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] |
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 xof@xxxxxxxxxxxx -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Home] [Yosemite]