Postgres Pro
Downloads
Home   >   mailing lists

Re: postgresql.conf recommendations - Mailing list pgsql-performance

From ac@hsk.hk
Subject Re: postgresql.conf recommendations
Date
Msg-id 13A05E96-01A0-4B0A-8EA3-2A3B7FDF6838@hsk.hk
Whole thread Raw
In response to Re: postgresql.conf recommendations  (Josh Krupka <jkrupka@gmail.com>)
Responses Re: postgresql.conf recommendations  (Kevin Grittner <kgrittn@ymail.com>)
List pgsql-performance
Tree view

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

On Tue, Feb 5, 2013 at 6:46 PM, Johnny Tan <johnnydtan@gmail.com> 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

pgsql-performance by date:

Previous
From: Pavan Deolasee
Date:
Subject: Re: postgresql.conf recommendations
Next
From: Pavan Deolasee
Date:
Subject: Re: Slow Query Help