Re: BUG #7494: WAL replay speed depends heavily on the shared_buffers size

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: BUG #7494: WAL replay speed depends heavily on the shared_buffers size
Дата
Msg-id 502BA6BD.5070308@hogranch.com
обсуждение исходный текст
Ответ на Re: BUG #7494: WAL replay speed depends heavily on the shared_buffers size  (Bruce Momjian <bruce@momjian.us>)
Ответы Re: BUG #7494: WAL replay speed depends heavily on the shared_buffers size
Список pgsql-bugs
On 08/15/12 6:36 AM, Bruce Momjian wrote:
> We warn against making shared buffers > 8GB, and this is perhaps another
> good reason.

I generally keep it at no more than 2gb as I've never found any
performance improvements going higher, on systems with 48gb ram, and had
more than a few performance degradations with larger shared buffers.



--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast

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

Предыдущее
От: Rikard Pavelic
Дата:
Сообщение: Re: BUG #7485: 9.2 beta3 libxml2 can't be loaded on Windows
Следующее
От: Dave Page
Дата:
Сообщение: Re: BUG #7485: 9.2 beta3 libxml2 can't be loaded on Windows