Re: PITR, checkpoint, and local relations

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: richt@multera.com
Cc: "Mikheev, Vadim" <vmikheev@SECTORBASE.COM>, "J. R. Nield" <jrnield@usol.com>, Bruce Momjian <pgman@candle.pha.pa.us>, PostgreSQL Hacker <pgsql-hackers@postgresql.org>
Date: 2002-08-07T15:40:34Z
Lists: pgsql-hackers
Richard Tucker <richt@multera.com> writes:
>>> Eh?  The kernel does that for you, as long as you're reading the
>>> same-size blocks that the backends are writing, no?

> We know for sure the kernel does this?  I think this is a dubious
> assumption.

Yeah, as someone pointed out later, it doesn't work if the kernel's
internal buffer size is smaller than our BLCKSZ.  So we do still need
the page images in WAL --- that protection against non-atomic writes
at the hardware level should serve for this problem too.

			regards, tom lane