Postgres Pro
Downloads
Home   >   mailing lists

Re: WAL Optimisation - configuration and usage - Mailing list pgsql-performance

From Tom Lane
Subject Re: WAL Optimisation - configuration and usage
Date
Msg-id 24768.1078189289@sss.pgh.pa.us
Whole thread Raw
In response to Re: WAL Optimisation - configuration and usage  ("Simon Riggs" <simon@2ndquadrant.com>)
Responses Re: WAL Optimisation - configuration and usage
List pgsql-performance
Tree view 
"Simon Riggs" <simon@2ndquadrant.com> writes:
> - why checkpoint interval of 300 secs causes them to happen every 10
> mins in quieter periods; is that an occaisional update occurring?

There is code in there to suppress a checkpoint if no WAL-loggable
activity has happened since the last checkpoint.  Not sure if that's
relevant to the issue or not though.

            regards, tom lane

pgsql-performance by date:

Previous
From: "Simon Riggs"
Date:
Subject: Re: WAL Optimisation - configuration and usage
Next
From: postgres@countup.de
Date:
Subject: Re: Select-Insert-Query