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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: 7k records into Sort node, 4.5m out?
Дата
Msg-id 20520.1345067076@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: 7k records into Sort node, 4.5m out?  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: 7k records into Sort node, 4.5m out?  (Josh Berkus <josh@agliodbs.com>)
Список 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 по дате отправления:

Предыдущее
От: Bosco Rama
Дата:
Сообщение: Re: cluster on conditional index?
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: 7k records into Sort node, 4.5m out?