Re: PITR, checkpoint, and local relations
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "J. R. Nield" <jrnield@usol.com>
Cc: Richard Tucker <richt@multera.com>,
Bruce Momjian <pgman@candle.pha.pa.us>, PostgreSQL Hacker <pgsql-hackers@postgresql.org>
Date: 2002-08-02T21:25:28Z
Lists: pgsql-hackers
"J. R. Nield" <jrnield@usol.com> writes: >> (In particular, I *strongly* object to using the buffer manager at all >> for reading files for backup. That's pretty much guaranteed to blow out >> buffer cache. Use plain OS-level file reads. An OS directory search >> will do fine for finding what you need to read, too.) > How do you get atomic block copies otherwise? Eh? The kernel does that for you, as long as you're reading the same-size blocks that the backends are writing, no? regards, tom lane