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

From Tom Lane
Subject Re: [HACKERS] [PATCH] Provide 8-byte transaction IDs to user level
Date
Msg-id 17604.1153944251@sss.pgh.pa.us
Whole thread Raw
In response to Re: [PATCH] Provide 8-byte transaction IDs to user level  (Bruce Momjian <bruce@momjian.us>)
Responses Re: [HACKERS] [PATCH] Provide 8-byte transaction IDs to user level  (Darcy Buskermolen <darcyb@commandprompt.com>)
Re: [HACKERS] [PATCH] Provide 8-byte transaction IDs to  (Bruce Momjian <bruce@momjian.us>)
List pgsql-patches
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?

            regards, tom lane

pgsql-patches by date:

Previous
From: Zdenek Kotala
Date:
Subject: Re: Allow commenting of variables in postgresql.conf to -
Next
From: Darcy Buskermolen
Date:
Subject: Re: [HACKERS] [PATCH] Provide 8-byte transaction IDs to user level