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

From Bruce Momjian
Subject Re: [HACKERS] [PATCH] Provide 8-byte transaction IDs to
Date
Msg-id 200607262118.k6QLIfE29763@momjian.us
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  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
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.)

Agreed.

--
  Bruce Momjian   bruce@momjian.us
  EnterpriseDB    http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

pgsql-patches by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: [HACKERS] [PATCH] Provide 8-byte transaction IDs to
Next
From: Darcy Buskermolen
Date:
Subject: Re: [HACKERS] [PATCH] Provide 8-byte transaction IDs to user level