RE: Re: TODO list

From: "Mikheev, Vadim" <vmikheev(at)SECTORBASE(dot)COM>
To: "'pgsql-hackers(at)postgresql(dot)org'" <pgsql-hackers(at)postgresql(dot)org>
Subject: RE: Re: TODO list
Date: 2001-04-06 02:36:54
Message-ID: 8F4C99C66D04D4118F580090272A7A234D3388@sectorbase1.sectorbase.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> > Blocks that have recently been written, but failed to make
> > it down to the disk platter intact, should be restorable from
> > the WAL log. So we do not need a block-level CRC to guard
> > against partial writes.
>
> If a block is missing some sectors in the middle, how would you know
> to reconstruct it from the WAL, without a block CRC telling you that
> the block is corrupt?

On recovery we unconditionally copy *entire* block content from the log
for each block modified since last checkpoint. And we do not write new
checkpoint record (ie do not advance recovery start point) untill we know
that all data blocks are flushed on disk (including blocks modified before
checkpointer started).

Vadim

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2001-04-06 02:52:08 Re: Re: TODO list
Previous Message Philip Warner 2001-04-06 02:07:07 Re: Re: TODO list