Re: postgresql.conf recommendations

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: postgresql.conf recommendations
Дата
Msg-id 1360185170.99635.YahooMailNeo@web162903.mail.bf1.yahoo.com
обсуждение исходный текст
Ответ на Re: postgresql.conf recommendations  (Johnny Tan <johnnydtan@gmail.com>)
Ответы Re: postgresql.conf recommendations
Список pgsql-performance
Johnny Tan <johnnydtan@gmail.com> wrote:

> Wouldn't this be controlled by our checkpoint settings, though?

Spread checkpoints made the issue less severe, but on servers with
a lot of RAM I've had to make the above changes (or even go lower
with shared_buffers) to prevent a burst of writes from overwhelming
the RAID controllers battery-backed cache.  There may be other
things which could cause these symptoms, so I'm not certain that
this will help; but I have seen this as the cause and seen the
suggested changes help.

-Kevin


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

Предыдущее
От: Josh Krupka
Дата:
Сообщение: Re: postgresql.conf recommendations
Следующее
От: Strahinja Kustudić
Дата:
Сообщение: Re: postgresql.conf recommendations