Re: Need help with one query

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Need help with one query
Дата
Msg-id 12521.1237595840@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Need help with one query  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: Need help with one query  (Anne Rosset <arosset@collab.net>)
Список pgsql-performance
Robert Haas <robertmhaas@gmail.com> writes:
> On Fri, Mar 20, 2009 at 1:16 PM, Anne Rosset <arosset@collab.net> wrote:
>> The db version is 8.2.4

> Something is wrong here.  How can setting enable_seqscan to off result
> in a plan with a far lower estimated cost than the original plan?

Planner bug no doubt ... given how old the PG release is, I'm not
particularly interested in probing into it now.  If Anne can still
reproduce this behavior on 8.2.something-recent, we should look closer.

            regards, tom lane

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Jignesh K. Shah"
Дата:
Сообщение: Re: Proposal of tunable fix for scalability of 8.4
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Need help with one query