Re: Re: Backup and Recovery

Bruce Momjian <pgman@candle.pha.pa.us> writes:
> In other words, we keep the page images and row records in one file so
> we can do one fsync, but once we have written the page, we don't want to
> store them for later point-in-time recovery.

What we'd want to do is strip the page images from the version of the
logs that's archived for recovery purposes.  Ideally the archiving
process would also discard records from aborted transactions, but I'm
not sure how hard that'd be to do.
        regards, tom lane