Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #7494: WAL replay speed depends heavily on the shared_buffers size - Mailing list pgsql-bugs

From John R Pierce
Subject Re: BUG #7494: WAL replay speed depends heavily on the shared_buffers size
Date
Msg-id 502BA6BD.5070308@hogranch.com
Whole thread Raw
In response to Re: BUG #7494: WAL replay speed depends heavily on the shared_buffers size  (Bruce Momjian <bruce@momjian.us>)
Responses Re: BUG #7494: WAL replay speed depends heavily on the shared_buffers size  (Valentine Gogichashvili <valgog@gmail.com>)
List pgsql-bugs
Tree view 
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 by date:

Previous
From: Rikard Pavelic
Date:
Subject: Re: BUG #7485: 9.2 beta3 libxml2 can't be loaded on Windows
Next
From: Dave Page
Date:
Subject: Re: BUG #7485: 9.2 beta3 libxml2 can't be loaded on Windows