Re: pgsql: Fast promote mode skips checkpoint at end of recovery. - Mailing list pgsql-committers

From Heikki Linnakangas
Subject Re: pgsql: Fast promote mode skips checkpoint at end of recovery.
Date
Msg-id 5107B318.70300@vmware.com
Whole thread Raw
In response to pgsql: Fast promote mode skips checkpoint at end of recovery.  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: pgsql: Fast promote mode skips checkpoint at end of recovery.
List pgsql-committers
On 29.01.2013 02:07, Simon Riggs wrote:
> +            /*
> +             * If we've been explicitly promoted with fast option,
> +             * end of recovery without a checkpoint if possible.
> +             */
> +            if (fast_promote)
> +            {
> +                checkPointLoc = ControlFile->prevCheckPoint;
> +                record = ReadCheckpointRecord(xlogreader, checkPointLoc, 2, false);
> +                if (record != NULL)
> +                {
> +                    checkpoint_wait = false;
> +                    CreateEndOfRecoveryRecord();
> +                }
> +            }

If we must have this ReadCheckPointRecord check, it needs more than zero
comments. Also, if it ever fails for some reason, I'd like to have a big
fat warning in the log to caution that something went badly wrong.

Why does it insist that we still have not only the latest checkpoint,
but the previous one too? At recovery, we fall back to the previous
checkpoint if we can't access the latest one, but that's just a
desperate measure to try to recover something if things have gone badly
wrong. It's OK to not have the WAL containing the previous checkpoint
still around. In particular, right after restoring from a base backup,
e.g with pg_basebackup -x, or with good old pg_start/stop_backup, the
WAL included with the backup won't stretch back to previous checkpoint.

- Heikki


pgsql-committers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: pgsql: Allow pgbench to use a scale larger than 21474.
Next
From: Simon Riggs
Date:
Subject: Re: pgsql: Fast promote mode skips checkpoint at end of recovery.