"Christopher Kings-Lynne" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org