Re: WAL shipping with archive_timeout & pg_switch_xlog()

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: wstrzalka <wstrzalka(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: WAL shipping with archive_timeout & pg_switch_xlog()
Date: 2008-04-24 15:18:06
Message-ID: 29038.1209050286@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

wstrzalka <wstrzalka(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Brendan Jurd 2008-04-24 15:29:50 Re: [HACKERS] I think this is a BUG?
Previous Message Tom Lane 2008-04-24 15:10:44 Re: plpgsql and logical expression evaluation