Re: [PERFORM] More benchmarking of wal_buffers - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: [PERFORM] More benchmarking of wal_buffers
Date
Msg-id GNELIHDDFBOCMGBFGEFOGEIPCFAA.chriskl@familyhealth.com.au
Whole thread Raw
In response to Re: More benchmarking of wal_buffers  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [PERFORM] More benchmarking of wal_buffers
List pgsql-hackers
> "Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:
> > Here's a question then - what is the _drawback_ to having 1024
> wal_buffers
> > as opposed to 8?
>
> Waste of RAM?  You'd be better off leaving that 8 meg available for use
> as general-purpose buffers ...

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?

Chris


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: location of the configuration files
Next
From: Kevin Brown
Date:
Subject: Re: Changing the default configuration (was Re: [pgsql-advocacy]