Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2
Дата
Msg-id 20167.1352236688@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-performance
Дерево обсуждения 
Merlin Moncure <mmoncure@gmail.com> writes:
> hm, wouldn't timing the time to generate a raw EXPLAIN (that is,
> without ANALYZE) give a rough estimate of planning time?   better to
> rule it out before OP goes to the trouble...

Well, we still wouldn't know *why* there was a problem ...

            regards, tom lane

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

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: Query completed in < 1s in PG 9.1 and ~ 700s in PG 9.2