Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk?

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk?
Дата
Msg-id 4B753363020000250002F259@gw.wicourts.gov
обсуждение исходный текст
Ответ на Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk?  (Karl Denninger <karl@denninger.net>)
Список pgsql-performance
Дерево обсуждения 
Karl Denninger <karl@denninger.net> wrote:
> Kevin Grittner wrote:

>> Have you seen such a difference under 8.4?  Can you provide a
>> self-contained example?

> Yes:
>
> [query and EXPLAIN ANALYZE of fast query]

> The alternative:
>
> [query with no other information]
>
> goes nuts.

Which means what?  Could you post an EXPLAIN ANALYZE, or at least an
EXPLAIN, of the slow version?  Can you post the table structure,
including indexes?

-Kevin

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

Предыдущее
От: Karl Denninger
Дата:
Сообщение: Re: 512,600ms query becomes 7500ms... but why? Postgres 8.3 query planner quirk?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Questions on plan with INSERT/SELECT on partitioned table