Re: 7k records into Sort node, 4.5m out? - Mailing list pgsql-performance

From Tom Lane
Subject Re: 7k records into Sort node, 4.5m out?
Date
Msg-id 20520.1345067076@sss.pgh.pa.us
Whole thread Raw
In response to Re: 7k records into Sort node, 4.5m out?  (Josh Berkus <josh@agliodbs.com>)
Responses Re: 7k records into Sort node, 4.5m out?  (Josh Berkus <josh@agliodbs.com>)
List pgsql-performance
Josh Berkus <josh@agliodbs.com> writes:
> On 8/15/12 1:51 PM, Tom Lane wrote:
>> Maybe you had better show us the actual query, and the table/index
>> definitions.  Because it's sure making odd choices here.  This seems
>> like the wrong join order altogether ...

> We'll need to do that off-list for confidentiality reasons.

If you can show us the anonymized query plan, why not the anonymized query?
It doesn't look like it could be all that complicated.

            regards, tom lane


pgsql-performance by date:

Previous
From: Bosco Rama
Date:
Subject: Re: cluster on conditional index?
Next
From: Josh Berkus
Date:
Subject: Re: 7k records into Sort node, 4.5m out?