Postgres Pro
Downloads
Home   >   mailing lists

Re: WAL monitoring and optimizing - Mailing list pgsql-performance

From Tom Lane
Subject Re: WAL monitoring and optimizing
Date
Msg-id 23936.1049133286@sss.pgh.pa.us
Whole thread Raw
In response to WAL monitoring and optimizing  (Marco Colombo <marco@esi.it>)
List pgsql-performance
Tree view 
Marco Colombo <marco@esi.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

pgsql-performance by date:

Previous
From: Marco Colombo
Date:
Subject: WAL monitoring and optimizing
Next
From: "scott.marlowe"
Date:
Subject: Re: Index not used, performance problem