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  (Peter van Hardenberg <pvh@pvh.ca>)
Список 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 по дате отправления:

Предыдущее
От: CSS
Дата:
Сообщение: Re: rough benchmarks, sata vs. ssd
Следующее
От: Peter van Hardenberg
Дата:
Сообщение: Re: random_page_cost = 2.0 on Heroku Postgres