Re: postgresql.conf recommendations

["ac@xxxxxx" <ac@xxxxxx>]

On 6 Feb 2013, at 12:23 PM, Josh Krupka wrote:

On Tue, Feb 5, 2013 at 6:46 PM, Johnny Tan <johnnydtan@xxxxxxxxx> wrote:

shared_buffers = 48GB # min 128kB

Hi,

From the postgresql.conf, I can see that the shared_buffers is set to 48GB which is not small,  it would be possible that the large buffer cache could be "dirty", when a checkpoint starts, it would cause a checkpoint I/O spike.

I would like to suggest you about using pgtune to get recommended conf for postgresql.

Regards