Horton

Re: PITR, checkpoint, and local relations

J.R. Nield <jrnield@usol.com>

View thread
From: "J. R. Nield" <jrnield@usol.com>
To: "Mikheev, Vadim" <vmikheev@SECTORBASE.COM>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Richard Tucker <richt@multera.com>, Bruce Momjian <pgman@candle.pha.pa.us>, PostgreSQL Hacker <pgsql-hackers@postgresql.org>
Date: 2002-08-02T21:12:20Z
Lists: pgsql-hackers 
On Fri, 2002-08-02 at 16:59, Mikheev, Vadim wrote:

> You don't need it.
> As long as whole block is saved in log on first after
> checkpoint (you made before backup) change to block.

I thought half the point of PITR was to be able to turn off pre-image
logging so you can trade potential recovery time for speed without fear
of data-loss. Didn't we have this discussion before?

How is this any worse than a table scan?
 
-- 
J. R. Nield
jrnield@usol.com