Re: Idea for nested transactions / savepoints - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Idea for nested transactions / savepoints
Date
Msg-id 8173.997022088@sss.pgh.pa.us
Whole thread Raw
In response to Idea for nested transactions / savepoints  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Idea for nested transactions / savepoints
List pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> My idea is that we not put UNDO information into WAL but keep a List of
> rel ids / tuple ids in the memory of each backend and do the undo inside
> the backend.

The complaints about WAL size amount to "we don't have the disk space
to keep track of this, for long-running transactions".  If it doesn't
fit on disk, how likely is it that it will fit in memory?
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Hiroshi Inoue"
Date:
Subject: RE: Re: OID wraparound: summary and proposal
Next
From: mlw
Date:
Subject: Re: Re: OID wraparound: summary and proposal