Re: proposal: Set effective_cache_size to greater of .conf value, shared_buffers

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: proposal: Set effective_cache_size to greater of .conf value, shared_buffers
Дата
Msg-id CA+U5nMJbwH78uXKZXB9_FQD_CWYsr5-Vrkk8-FdD6tpU1VK=+g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: proposal: Set effective_cache_size to greater of .conf value, shared_buffers  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: proposal: Set effective_cache_size to greater of .conf value, shared_buffers
Список pgsql-hackers
On 6 May 2014 23:47, Josh Berkus <josh@agliodbs.com> wrote:

> If you're going to make
> an argument in favor of different tuning advice, then do it based on
> something in which you actually believe, based on hard evidence.

The proposed default setting of 4x shared_buffers is unprincipled
*and* lacks hard evidence from you and everybody else.

You've used the phrase "conventional wisdom" to describe things which
you have spoken loudly about.  I personally have not seen sufficient
evidence to rely on that as wisdom.

I note that my detailed comments as to why it is unsafe have been
ignored, again.

-- Simon Riggs                   http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services



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

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: New pg_lsn type doesn't have hash/btree opclasses
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: proposal: Set effective_cache_size to greater of .conf value, shared_buffers