Josh Berkus <josh@agliodbs.com> writes: > Folks, > > 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 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? -- greg ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org