Greg, > You have wal_buffer set to 2048? That's pretty radical compared to the > default of just 5. Your tests shows you had to go to this large a value > to see the maximum effect?
No, take a look at the graph. It looks like we got the maximum effect from a wal_buffers somewhere between 64 and 256. On the DBT2 runs, any variation less than 5% is just noise. -- --Josh Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend