Re: Checkpoints vs restartpoints

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Checkpoints vs restartpoints
Date: 2015-06-10 01:09:07
Message-ID: CAB7nPqSfhFqYsHweiOHdK6EieL+=R-AS4orh9LsWe=R6aTgTrA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Jun 10, 2015 at 9:33 AM, Bruce Momjian wrote:
> Ah, so even thought standbys don't have to write WAL, they are fsyncing
> shared buffers. Where is the restart point recorded, in pg_controldata?
> c

Yep. Latest checkpoint's REDO location, or
ControlFile->checkPointCopy.redo. During recovery, a copy is kept as
well in XLogCtlData.lastCheckPoint.
--
Michael

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2015-06-10 01:56:13 Re: Run pgindent now?
Previous Message Michael Paquier 2015-06-10 00:54:22 Re: pg_archivecleanup bug (invalid filename input)