Re: WAL monitoring and optimizing

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Marco Colombo <marco(at)esi(dot)it>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: WAL monitoring and optimizing
Date: 2003-03-31 17:54:46
Message-ID: 23936.1049133286@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Marco Colombo <marco(at)esi(dot)it> writes:
> I've got 7365 'XLogFlush:' lines and 23275 'INSERT @' lines in the
> last 9 hours. Should I increase the number of WAL buffers?

With a transaction rate as low as that, I wouldn't think you need to.

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message scott.marlowe 2003-03-31 18:21:45 Re: Index not used, performance problem
Previous Message Marco Colombo 2003-03-31 12:06:50 WAL monitoring and optimizing