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