Re: High load,

* Michael Kohl (michael(dot)kohl(at)tupalo(dot)com) wrote:
> HDD: 2x 120 GB OCZ Vertex 2 SSD; RAID 1

I'm amazed no one else has mentioned this yet, but you should look into
splitting your data and your WALs. Obviously, having another set of
SSDs to put your WALs on would be ideal.

You should probably also be looking into adjustments to the background
writer. It sounds like you're getting hit by large checkpoint i/o
(if you turn on logging of that, as someone else suggested, you'll be
able to corrollate the times), which can be helped by increasing the
amount of writing done between checkpoints, so that the checkpoints
aren't as big and painful. That can be done by making the background
writer more aggressive.

Thanks,

Stephen