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

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #7494: WAL replay speed depends heavily on the shared_buffers size
Date: 2012-08-15 13:40:13
Message-ID: 502BA6BD.5070308@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Dave Page 2012-08-15 13:43:36 Re: BUG #7485: 9.2 beta3 libxml2 can't be loaded on Windows
Previous Message Rikard Pavelic 2012-08-15 13:37:47 Re: BUG #7485: 9.2 beta3 libxml2 can't be loaded on Windows