On 6 Feb 2013, at 12:23 PM, Josh Krupka wrote: > On Tue, Feb 5, 2013 at 6:46 PM, Johnny Tan <johnnyd...@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
