subject:"\[GENERAL\] Understanding sort's memory\/disk usage"

Re: [GENERAL] Understanding sort's memory/disk usage

2009-09-27 Thread Tom Lane

Adam Rich writes: > Please reference these explain plans. This is Pg 8.4.1 > http://explain-analyze.info/query_plans/4032-query-plan-2745 > http://explain-analyze.info/query_plans/4033-query-plan-2746 > First, could somebody explain what is leading the first query to choose > a different plan

[GENERAL] Understanding sort's memory/disk usage

2009-09-27 Thread Adam Rich

Hello, Please reference these explain plans. This is Pg 8.4.1 http://explain-analyze.info/query_plans/4032-query-plan-2745 http://explain-analyze.info/query_plans/4033-query-plan-2746 First, could somebody explain what is leading the first query to choose a different plan that's much slower?