Re: PITR, checkpoint, and local relations - Mailing list pgsql-hackers

From Tom Lane
Subject Re: PITR, checkpoint, and local relations
Date
Msg-id 16270.1028734834@sss.pgh.pa.us
Whole thread Raw
In response to PITR, checkpoint, and local relations  ("J. R. Nield" <jrnield@usol.com>)
List 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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Open 7.3 items
Next
From: Joe Conway
Date:
Subject: Re: Heap tuple header issues