Re: Savepoints

From: "Zeugswetter Andreas SB SD" <ZeugswetterA(at)spardat(dot)at>
To: "Mikheev, Vadim" <vmikheev(at)SECTORBASE(dot)COM>, "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>, "PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Savepoints
Date: 2002-01-25 14:21:22
Message-ID: 46C15C39FEB2C44BA555E356FBCD6FA42128DE@m0114.s-mxs.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Vadim wrote:
> How about: use overwriting smgr + put old records into rollback
> segments - RS - (you have to keep them somewhere till TX's running
> anyway) + use WAL only as REDO log (RS will be used to rollback TX'
> changes and WAL will be used for RS/data files recovery).
> Something like what Oracle does.

We have all the info we need in WAL and in the old rows,
why would you want to write them to RS ?
You only need RS for overwriting smgr.

Andreas

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-01-25 15:19:25 Re: RTREE Index on primary key generated by a sequence
Previous Message Oliver Friedrich 2002-01-25 14:18:49 Re: Inserting Non English characters in a varchar type field