Re: postgresql.conf recommendations

From: "ac(at)hsk(dot)hk" <ac(at)hsk(dot)hk>
To: Josh Krupka <jkrupka(at)gmail(dot)com>, Johnny Tan <johnnydtan(at)gmail(dot)com>
Cc: ac(at)hsk(dot)hk, Alex Kahn <alex(at)paperlesspost(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: postgresql.conf recommendations
Date: 2013-02-06 06:18:29
Message-ID: 13A05E96-01A0-4B0A-8EA3-2A3B7FDF6838@hsk.hk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


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

> On Tue, Feb 5, 2013 at 6:46 PM, Johnny Tan <johnnydtan(at)gmail(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Pavan Deolasee 2013-02-06 08:51:14 Re: Slow Query Help
Previous Message Pavan Deolasee 2013-02-06 06:00:06 Re: postgresql.conf recommendations