"Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:
> What I mean is say you have an enterprise server doing heaps of transactions
> with lots of work. If you have scads of RAM, could you just shove up
> wal_buffers really high and assume it will improve performance?
There is no such thing as infinite RAM (or if there is, you paid *way*
too much for your database server). My feeling is that it's a bad
idea to put more than you absolutely have to into single-use buffers.
Multi-purpose buffers are usually a better use of RAM.
regards, tom lane
