Re: Confirmation of bad query plan generated by 7.4

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Confirmation of bad query plan generated by 7.4
Дата
Msg-id 16554.1150339015@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Confirmation of bad query plan generated by 7.4  (Jim Nasby <jnasby@pervasive.com>)
Ответы Re: Confirmation of bad query plan generated by 7.4  ("Jim C. Nasby" <jnasby@pervasive.com>)
Список pgsql-performance
Jim Nasby <jnasby@pervasive.com> writes:
> On Jun 13, 2006, at 8:50 PM, Tom Lane wrote:
>> Hmm ... worksforme.  Could you provide a complete test case?

> decibel=# create table date_test(d date not null, i int not null);
> [etc]

Not sure what you are driving at.  The estimates are clearly not
defaults (the default estimate would be 1/3rd of the table, or
about 100mil rows).  Are you expecting them to be the same?  If so why?
The comparison values are slightly different after all.

            regards, tom lane

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

Предыдущее
От: Jim Nasby
Дата:
Сообщение: Re: Confirmation of bad query plan generated by 7.4
Следующее
От: Greg Stark
Дата:
Сообщение: Re: Postgres fsync off (not needed) with NetApp