From:
Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To:
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc:
Manfred Koizar <mkoi-pg(at)aon(dot)at>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>,David Blasby <dblasby(at)refractions(dot)net>, pgsql-hackers(at)postgresql(dot)org
Subject:
Re: Nested transactions and tuple header info
Date:
2004-06-01 22:55:39
Message-ID:
20040601225539.GA29011@dcc.uchile.cl (view raw or flat )
Thread:
2004-05-26 21:00:47 from David Blasby <dblasby(at)refractions(dot)net>
2004-05-26 21:17:08 from Gaetano Mendola <mendola(at)bigfoot(dot)com>
2004-05-26 21:55:27 from David Blasby <dblasby(at)refractions(dot)net>
2004-05-26 22:28:25 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2004-05-26 23:02:42 from David Blasby <dblasby(at)refractions(dot)net>
2004-05-27 02:21:19 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2004-05-27 03:55:15 from Paul Ramsey <pramsey(at)refractions(dot)net>
2004-05-27 16:26:54 from David Blasby <dblasby(at)refractions(dot)net>
2004-05-26 23:26:20 from pgsql(at)mohawksoft(dot)com
2004-05-26 22:17:55 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2004-05-27 01:36:33 from Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
2004-05-27 02:06:13 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2004-05-27 06:13:23 from Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org>
2004-05-27 13:29:46 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2004-05-27 18:07:31 from Manfred Koizar <mkoi-pg(at)aon(dot)at>
2004-05-27 18:23:07 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2004-05-27 19:52:30 from Manfred Koizar <mkoi-pg(at)aon(dot)at>
2004-05-27 20:50:24 from Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
2004-05-28 18:29:51 from Manfred Koizar <mkoi-pg(at)aon(dot)at>
2004-05-28 18:47:01 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2004-05-28 19:05:42 from Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
2004-05-28 19:19:29 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2004-05-28 19:36:15 from Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
2004-05-28 19:48:11 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2004-05-28 20:03:19 from Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
2004-05-28 20:45:28 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2004-05-29 01:16:33 from Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
2004-05-29 01:59:53 from Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
2004-06-01 12:37:37 from Manfred Koizar <mkoi-pg(at)aon(dot)at>
2004-06-01 12:53:50 from Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
2004-06-01 22:40:07 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2004-06-01 22:55:39 from Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
2004-06-01 23:28:59 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2004-06-02 03:17:40 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2004-06-02 03:44:13 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2004-06-02 03:50:13 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2004-06-02 03:50:42 from Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
2004-06-02 03:59:14 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2004-06-02 13:52:28 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2004-06-02 14:03:15 from Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
2004-06-02 14:22:28 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2004-06-02 14:47:04 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2004-06-02 14:53:47 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2004-06-02 14:57:05 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2004-06-02 15:12:31 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2004-06-02 15:47:33 from Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
2004-06-02 16:23:37 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2004-06-02 16:46:37 from Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
2004-06-02 16:53:55 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2004-06-03 20:21:06 from Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
2004-06-03 21:08:42 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2004-06-02 14:44:07 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2004-06-11 07:07:58 from Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
2004-06-13 06:32:38 from Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
2004-06-13 17:22:05 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2004-06-13 22:02:16 from Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
2004-06-13 14:09:30 from Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
2004-06-01 12:39:13 from Manfred Koizar <mkoi-pg(at)aon(dot)at>
Lists:
pgsql-hackers
On Tue, Jun 01, 2004 at 06:40:07PM -0400, Bruce Momjian wrote:
> So, we need a way to record the xmin and xmax while keeping cmin and
> cmax in the tuple header. My idea is for subtransactions to create
> additional xid's that represent the opposite of the commit state for
> changing tuples created by earlier subtransactions.
Hmm, interesting idea. What seems more interesting is that the change
seems to be confined to HeapTupleHeaderSetXmax. Every transaction and
subtransaction will need two Xids (I think we can even optimize it so
the "abort xid" is taken only as needed).
I don't see anything immediately that would invalidate this idea. I'll
marinate it while I write the trigger stuff, and wait for other
comments. If nothing bad arises I'll try an implementation and report
back.
Thanks,
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Nunca confiaré en un traidor. Ni siquiera si el traidor lo he creado yo"
(Barón Vladimir Harkonnen)
In response to
pgsql-hackers by date
Next :From: Tom LaneDate: 2004-06-01 23:28:59Subject : Re: Nested transactions and tuple header info Previous :From : Bruce MomjianDate : 2004-06-01 22:40:07Subject : Nested transactions and tuple header info
