Re: Avoiding shutdown checkpoint at failover - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Avoiding shutdown checkpoint at failover
Date
Msg-id CA+TgmobCfLA532Ji6p0r6tWStPTKA7x53AGsSY9V60Ki3DShqQ@mail.gmail.com
Whole thread Raw
In response to Re: Avoiding shutdown checkpoint at failover  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: Avoiding shutdown checkpoint at failover
Re: Avoiding shutdown checkpoint at failover
List pgsql-hackers
On Sat, Jan 28, 2012 at 8:57 AM, Simon Riggs <simon@2ndquadrant.com> wrote:
> On Thu, Jan 26, 2012 at 5:27 AM, Fujii Masao <masao.fujii@gmail.com> wrote:
>
>> One thing I would like to ask is that why you think walreceiver is more
>> appropriate for writing XLOG_END_OF_RECOVERY record than startup
>> process. I was thinking the opposite, because if we do so, we might be
>> able to skip the end-of-recovery checkpoint even in file-based log-shipping
>> case.
>
> Right now, WALReceiver has one code path/use case.
>
> Startup has so many, its much harder to know whether we'll screw up one of them.
>
> If we can add it in either place then I choose the simplest, most
> relevant place. If the code is the same, we can move it around later.
>
> Let me write the code and then we can think some more.

Are we still considering trying to do this for 9.2?  Seems it's been
over a month without a new patch, and it's not entirely clear that we
know what the design should be.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Finer Extension dependencies
Next
From: Robert Haas
Date:
Subject: Re: Review of pg_archivecleanup -x option patch