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.
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.