Re: random_page_cost = 2.0 on Heroku Postgres

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: random_page_cost = 2.0 on Heroku Postgres
Дата
Msg-id CAMkU=1x=p2qSssS65PFrD+8dWhae01x8xxbeV30cZJF8aOyGZQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: random_page_cost = 2.0 on Heroku Postgres  (Peter van Hardenberg <pvh@pvh.ca>)
Ответы Re: random_page_cost = 2.0 on Heroku Postgres
Список pgsql-performance
On Thu, Feb 9, 2012 at 2:41 PM, Peter van Hardenberg <pvh@pvh.ca> wrote:

> Hmm, perhaps we could usefully aggregate auto_explain output.

By the time you realize the query is running long, it is too late to
start analyzing it.  And without analyzing it, you probably can't get
the information you need.

Maybe with the timing = off feature,it would might make sense to just
preemptively analyze everything.

Cheers,

Jeff

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