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