[PERFORM] Tuning for warm standby

Hi All;

I'm preparing to fire up WAL archiving on 8 production servers We will follow up with implementing a warm standby scenariio.

Does anyone have any thoughts per how to maximize performance, yet minimize the potential for data loss assuming we were not able to retrieve the final un-archived WAL segment from the original pg_xlog dir in the case of a crash?

Specifically, I wonder if there are some general rules of thought per tuning wal_buffers, checkpoint_segments and friends...

Currently all servers have the following settings: wal_buffers = 24
checkpoint_segments = 32

Thanks in advance

/Kevin

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match