From:
Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To:
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Manfred Koizar <mkoi-pg(at)aon(dot)at>,David Blasby <dblasby(at)refractions(dot)net>, pgsql-hackers(at)postgresql(dot)org
Subject:
Re: Nested transactions and tuple header info
Date:
2004-06-03 20:21:06
Message-ID:
20040603202106.GA31283@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 Wed, Jun 02, 2004 at 10:57:05AM -0400, Bruce Momjian wrote:
> Tom Lane wrote:
>
> > No, I said own xid --- so the "phantom xid" part is still there. But
> > your idea definitely does *not* work unless you use a single CID
> > sequence for the whole main xact; and I'm still wondering if there's
> > not a simpler implementation possible given that assumption.
>
> I don't understand why a single counter is needed for phantom xids. We
> keep the cmin/cmax on the tuple already, and our own backend can look up
> the xmin/xmax that goes with the phantom.
Not sure either way (maybe you are right), but I use the global counter
anyway because some tests would become a very ugly mess if I didn't. I
think the phantom idea is also simpler with the global counter.
And I see no reason to use local counter. We certainly are not
hitting the limit with the global counter, as Tom pointed out recently
in a thread about the aborted CID bitmaps.
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Crear es tan difícil como ser libre" (Elsa Triolet)
In response to
Responses
pgsql-hackers by date
Next :From: Alvaro HerreraDate: 2004-06-03 20:49:03Subject : Re: Check for prepared statementPrevious :From : Joshua D. DrakeDate : 2004-06-03 20:18:23Subject : Re: [HACKERS] Not 7.5, but 8.0 ?
