News for hackers. Stuff that matters.
Re:PostgreSQL tips and tricks by jnsaff on Sunday May 29, 2011 @11:09PM (#2598354)
One thing that helped us a lot was setting

checkpoint_completion_target = 0.9 # up from 0.5 default

So the checkpoints get written out more evenly and cause less and shorter "stop the world" events. This was especially painful on Amazon EBS (which is a relatively bad idea by itself btw) with large shared memory size. Decreasing this actually improved performance for us.

There are no comments on this comment yet.