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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: 7k records into Sort node, 4.5m out?
Date: 2012-08-15 21:44:36
Message-ID: 20520.1345067076@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Josh Berkus <josh(at)agliodbs(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Josh Berkus 2012-08-16 00:25:06 Re: 7k records into Sort node, 4.5m out?
Previous Message Bosco Rama 2012-08-15 21:19:08 Re: cluster on conditional index?