Re: Keepalive for max_standby_delay - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: Keepalive for max_standby_delay
Date
Msg-id 4C2F260E.10100@enterprisedb.com
Whole thread Raw
In response to Re: Keepalive for max_standby_delay  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Keepalive for max_standby_delay
List pgsql-hackers
On 02/07/10 23:36, Tom Lane wrote:
> Robert Haas<robertmhaas@gmail.com>  writes:
>> I haven't been able to wrap my head around why the delay should be
>> LESS in the archive case than in the streaming case.  Can you attempt
>> to hit me with the clue-by-four?
>
> In the archive case, you're presumably trying to catch up, and so it
> makes sense to kill queries faster so you can catch up.  The existing
> code essentially forces instant kill when reading from archive, for any
> reasonable value of max_standby_delay (because the archived timestamps
> will probably be older than that).  That's overenthusiastic in my view,
> but you can get that behavior if you want it with this patch by setting
> max_standby_archive_delay to zero.  If you don't want it, you can use
> something larger.  If you don't think that max_standby_archive_delay
> should be less than max_standby_streaming_delay, you can set them the
> same, too.

It would seem logical to use the same logic for archive recovery as we 
do for streaming replication, and only set XLogReceiptTime when you have 
to wait for a WAL segment to arrive into the archive, ie. when 
restore_command fails.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Keeping separate WAL segments for each database
Next
From: Robert Haas
Date:
Subject: Re: reassign owned to change the ownership for op class and family