Re: random_page_cost = 2.0 on Heroku Postgres

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: random_page_cost = 2.0 on Heroku Postgres
Дата
Msg-id CAOR=d=3CqkNHvznRggv5HvY8C=Pex1EO9XQ2giNKX6VnL8LTyw@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>)
Re: random_page_cost = 2.0 on Heroku Postgres  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-performance
On Wed, Feb 8, 2012 at 6:45 PM, Peter van Hardenberg <pvh@pvh.ca> wrote:
> Having read the thread, I don't really see how I could study what a
> more principled value would be.

Agreed.  Just pointing out more research needs to be done.

> That said, I have access to a very large fleet in which to can collect
> data so I'm all ears for suggestions about how to measure and would
> gladly share the results with the list.

I wonder if some kind of script that grabbed random queries and ran
them with explain analyze and various random_page_cost to see when
they switched and which plans are faster would work?

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

Предыдущее
От: Peter van Hardenberg
Дата:
Сообщение: Re: random_page_cost = 2.0 on Heroku Postgres
Следующее
От: Marcos Ortiz Valmaseda
Дата:
Сообщение: Re: random_page_cost = 2.0 on Heroku Postgres