Re: wal_buffer tests in

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