Re: WAL shipping with archive_timeout & pg_switch_xlog() - Mailing list pgsql-general

From Tom Lane
Subject Re: WAL shipping with archive_timeout & pg_switch_xlog()
Date
Msg-id 29038.1209050286@sss.pgh.pa.us
Whole thread Raw
In response to WAL shipping with archive_timeout & pg_switch_xlog()  (wstrzalka <wstrzalka@gmail.com>)
List pgsql-general
wstrzalka <wstrzalka@gmail.com> writes:
> archive_timeout is used for WAL shipping to standby server in my case
> (are there any other reasons?), but WAL is switched by the timeout
> even if there are no changes on the server.

This is intentional.  Some people consider the arrival of a new WAL file
to be a good heartbeat monitor, and they want to see one go by every
so many seconds whether the database is busy or not.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: plpgsql and logical expression evaluation
Next
From: "Brendan Jurd"
Date:
Subject: Re: [HACKERS] I think this is a BUG?