RE: AW: AW: Re: Backup and Recovery - Mailing list pgsql-hackers

From Mikheev, Vadim
Subject RE: AW: AW: Re: Backup and Recovery
Date
Msg-id 3705826352029646A3E91C53F7189E320166AD@sectorbase2.sectorbase.com
Whole thread Raw
In response to AW: AW: Re: Backup and Recovery  (Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at>)
List pgsql-hackers
> Good point.  We'd have to recognize btree splits (and possibly some
> other operations) as things that must be done anyway, even if their
> originating transaction is aborted.
> 
> There already is a mechanism for doing that: xlog entries can
> be written without any transaction identifier (see XLOG_NO_TRAN).
> Seems to me that btree split XLOG records should be getting written
> that way now --- Vadim, don't you agree?

We would have to write two records per split instead of one as now.
Another way is new xlog AM method: we have XXX_redo, XXX_undo (unfunctional)
and XXX_desc (for debug output) now - add XXX_compact (or whatever)
able to modify record somehow for BAR. For heap, etc this method could
be {return} (or NULL) and for btree it could remove inserted tuple
from record (for aborted TX).

Vadim



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Database Users Management and Privileges
Next
From: "Jean-Francois Leveque"
Date:
Subject: Re: Database Users Management and Privileges