* Michael Kohl (michael.kohl@xxxxxxxxxx) 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
Attachment:
signature.asc
Description: Digital signature
