Re: Savepoints - Mailing list pgsql-hackers

From Zeugswetter Andreas SB SD
Subject Re: Savepoints
Date
Msg-id 46C15C39FEB2C44BA555E356FBCD6FA42128DE@m0114.s-mxs.net
Whole thread Raw
In response to Savepoints  (Bruce Momjian <pgman@candle.pha.pa.us>)
List 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


pgsql-hackers by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: RTREE Index on primary key generated by a sequence
Next
From: Tom Lane
Date:
Subject: Re: RTREE Index on primary key generated by a sequence