Re: [HACKERS] [PATCH] Provide 8-byte transaction IDs to user level - Mailing list pgsql-patches

From Darcy Buskermolen
Subject Re: [HACKERS] [PATCH] Provide 8-byte transaction IDs to user level
Date
Msg-id 200607261341.10727.darcyb@commandprompt.com
Whole thread Raw
In response to Re: [HACKERS] [PATCH] Provide 8-byte transaction IDs to user level  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [HACKERS] [PATCH] Provide 8-byte transaction IDs to user level  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: [HACKERS] [PATCH] Provide 8-byte transaction IDs to  (Hannu Krosing <hannu@skype.net>)
List pgsql-patches
On Wednesday 26 July 2006 13:04, Tom Lane wrote:
> Bruce Momjian <bruce@momjian.us> writes:
> > I am sure you worked hard on this, but I don't see the use case, nor
> > have I heard people in the community requesting such functionality.
> > Perhaps pgfoundry would be a better place for this.
>
> The part of this that would actually be useful to put in core is
> maintaining a 64-bit XID counter, ie, keep an additional counter that
> bumps every time XID wraps around.  This cannot be done very well from
> outside core but it would be nearly trivial, and nearly free, to add
> inside.  Everything else in the patch could be done just as well as an
> extension datatype.
>
> (I wouldn't do it like this though --- TransactionIdAdvance itself is
> the place to bump the secondary counter.)
>
> The question though is if we did that, would Slony actually use it?

If it made sence to do it, then yes we would do it. The problem ends up being
Slony is designed to work across a multitude of versions of PG, and unless
this was backported to at least 7.4, it would take a while (ie when we
stopped supporting versions older than it was ported into)  before we would
make use of it.

>
>             regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster

--
Darcy Buskermolen
CommandPrompt, Inc.
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
http://www.commandprompt.com


pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] [PATCH] Provide 8-byte transaction IDs to user level
Next
From: Tom Lane
Date:
Subject: Re: extension for sql update