> > Am I correct that with no UNDO in 7.1.X, we should only be keeping one
> > WAL file around, or maybe two?
>
> Not necessarily. How much do you do between checkpoints?
>
> But yeah, there's no reason to save data further back than one or maybe
> two checkpoints, as long as UNDO isn't there.
I am thinking of long transactions that keep extra WAL files around.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026