> I ran a wal_buffer test series. It appears that increasing the > wal_buffers is indeed very important for OLTP applications, > potentially resulting in as much as a 15% average increase in > transaction processing. > What's interesting is that this is not just true for 8.1, it's true for > 8.0.3 as well.
You will want the log write to write up to at least 256kb (>= 256kb you reach the max Mb/s a disk can write) (if that is possible, no commit/fsync inbetween). You will also want enough buffers, that can be filled while the 256kb are written. Thus a value of at least 64 with 8k pages seems reasonable. Andreas ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
