Re: Automagic tuning

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Automagic tuning
Дата
Msg-id 3900.1107203172@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Automagic tuning  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: Automagic tuning  ("Jim C. Nasby" <decibel@decibel.org>)
Список pgsql-performance
Josh Berkus <josh@agliodbs.com> writes:
>> I would like something that really measures values like random_page_cost
>> or cpu_tuple_cost that are hardware dependent.
>>
>> I assume such thing does not exist?

> Nope.  You gotta whip out your calculator and run some queries.

Preferably a whole lot of queries.  All the measurement techniques I can
think of are going to have a great deal of noise, so you shouldn't
twiddle these cost settings based on just a few examples.

            regards, tom lane

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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: Automagic tuning
Следующее
От: Cosimo Streppone
Дата:
Сообщение: High end server and storage for a PostgreSQL OLTP system