Re: Strangely Variable Query Performance

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Strangely Variable Query Performance
Дата
Msg-id 10067.1176420549@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Strangely Variable Query Performance  (Steve <cheetah@tanabi.org>)
Ответы Re: Strangely Variable Query Performance
Список pgsql-performance
Steve <cheetah@tanabi.org> writes:
> Here's my planner parameters:

I copied all these, and my 8.2.x still likes the bitmap scan a lot
better than the seqscan.  Furthermore, I double-checked the CVS history
and there definitely haven't been any changes in that area in REL8_2
branch since 8.2.3.  So I'm a bit baffled.  Maybe the misbehavior is
platform-specific ... what are you on exactly?  Is there anything
nonstandard about your Postgres installation?

            regards, tom lane

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

Предыдущее
От: Steve
Дата:
Сообщение: Re: Strangely Variable Query Performance
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Strangely Variable Query Performance