Re: PITR: XLog File compression on Archive

From: "Zeugswetter Andreas SB SD" <ZeugswetterA(at)spardat(dot)at>
To: "Simon Riggs" <simon(at)2ndquadrant(dot)com>, "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>, "PostgreSQL-development" <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: PITR: XLog File compression on Archive
Date: 2004-08-24 08:08:53
Message-ID: 46C15C39FEB2C44BA555E356FBCD6FA40184D17A@m0114.s-mxs.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


> Re-thinking the whole purpose of the additional full page images appended to
> the xlog records, I now understand and agree with Tom's comment in the docs
> that we don't need to include those additional full page images for PITR -
> they only exist to correctly recover the database in the event of a crash.
> The reason for this is that the base backup provides a full set of blocks on
> which to recover - there is no danger that the backup contains bad blocks,
> as would be the case for crash recovery.

It is correct, that the base backup cannot contain bad blocks (on OS's we know).
But it can contain newer blocks than WAL records would expect.
Will it not matter if e.g. a page split for a btree index is already in the
index file, but a WAL record exists, that references the not yet split page?
I think not, but I am not sure, since normal crash recovery won't see this
situation because of the page images (that can be older than what is on disk).

Also is there not now code, that logs index recreation by only logging
page images ? We would still need those, no ?

Andreas

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Shinji Teragaito 2004-08-24 08:23:19 Re: HP-UX PA-RISC/Itanium 64-bit Patch and HP-UX 11.23 Patch
Previous Message Zeugswetter Andreas SB SD 2004-08-24 08:05:59 Re: 8.0 beta 1 on linux-mipsel R5900