Re: Patch for fail-back without fresh backup - Mailing list pgsql-hackers

From Greg Stark
Subject Re: Patch for fail-back without fresh backup
Date
Msg-id CAM-w4HPNifdXnC0zvUui7C1Q0Rv6j98kR60NNrw3_rbTVRPU3w@mail.gmail.com
Whole thread Raw
In response to Re: Patch for fail-back without fresh backup  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Patch for fail-back without fresh backup  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Fri, Jun 14, 2013 at 2:21 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> So it's not that we actually need to log the individual hint bit
> changes, it's that we need to WAL-log a full page image on the first
> update after a checkpoint, so as to recover from torn-page cases.
> Which one are we doing?

Wal logging a full page image after a checkpoint wouldn't actually be
enough since subsequent hint bits will dirty the page and not wal log
anything creating a new torn page risk. FPI are only useful if all the
subsequent updates are wal logged.




-- 
greg



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Add visibility map information to pg_freespace.
Next
From: Tom Lane
Date:
Subject: Re: Patch for fail-back without fresh backup