* Jonah H. Harris <jonah(dot)harris(at)gmail(dot)com> [081002 14:01]:
> On Thu, Oct 2, 2008 at 1:58 PM, Gregory Stark <stark(at)enterprisedb(dot)com> wrote:
> >> On recovery after a torn-page write, won't the recovery of the
> >> full_page_write WAL + WAL changes get us back to the page as it was
> >> before the buffer+checksum+write?
> > Hint bit setting doesn't trigger a WAL record.
> Hence, no page image is written to WAL for later use in recovery.
OK. Got it... The block is dirty (only because of hint bits). write
starts, crash, torn page, recovery doesn't "fix" the torn page...
because it's never been changed (according WAL), so on next read...
Without the CRC it doesn't matter, because the only change was
hint-bits, so the page is half-old+half-new, but new == old+only
Because ther'es no WAP. the torn page will be read next time that buffer
Aidan Van Dyk Create like a god,
aidan(at)highrise(dot)ca command like a king,
http://www.highrise.ca/ work like a slave.
In response to
pgsql-hackers by date
|Next:||From: Heikki Linnakangas||Date: 2008-10-02 18:15:49|
|Subject: Re: FSM rewrite committed, loose ends|
|Previous:||From: Jonah H. Harris||Date: 2008-10-02 18:04:56|
|Subject: Re: Block-level CRC checks|