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

From Tom Lane
Subject Re: Avoiding shutdown checkpoint at failover
Date
Msg-id 24926.1320155288@sss.pgh.pa.us
Whole thread Raw
In response to Avoiding shutdown checkpoint at failover  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: Avoiding shutdown checkpoint at failover
List pgsql-hackers
Simon Riggs <simon@2ndQuadrant.com> writes:
> The reason we run a shutdown checkpoint is to prevent needing to
> re-enter recovery if we crash after promotion.

That's *a* reason, it's not necessarily the only reason.  This proposal
worries me, especially your blithe dismissal of the timeline issues;
but in any case I would not trust it without a detailed review of all
WAL replay activities, which you don't sound to have done.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: IDLE in transaction introspection
Next
From: Tom Lane
Date:
Subject: Re: IDLE in transaction introspection