Re: [PERFORM] 7k records into Sort node, 4.5m out?

2012-08-15 Thread Christophe Pettus
'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

Re: [PERFORM] 7k records into Sort node, 4.5m out?

2012-08-13 Thread Christophe Pettus
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

[PERFORM] 7k records into Sort node, 4.5m out?

2012-08-13 Thread Christophe Pettus
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