'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 y
On Aug 13, 2012, at 6:35 PM, Tomas Vondra wrote:
> On 14 Srpen 2012, 3:15, Christophe Pettus wrote:
>> Consider this EXPLAIN ANALYZE output:
>>
>> http://explain.depesz.com/s/TCi
>>
>> Note the Bitmap Heap Scan at the bottom claims to be producing 70
actually producing
4512231 rows, which the sort time would indicate is what really happened. How
can this be?
--
-- 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