[RFC] txid: module for 64-bit external transaction IDs

From: "Marko Kreen" <markokr(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: [RFC] txid: module for 64-bit external transaction IDs
Date: 2006-06-30 21:29:25
Message-ID: e51f66da0606301429h73cebcach8a2d7ff8eefaa159@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Here's how we solved the XID indexing problem at Skype. We took
Slony-s xxid module and made it output 8-byte numbers by keeping
track of wraparound count. Thus having stable relationship
between values.

It would be good to have such functionality officially in PostgreSQL
so that all replication (and other) projects can benefit from it.
Either as a contrib module or in core.

Actually I have started porting the module into core, because
I feel the administration will be easier that way. I hoped
to post a preview of it and then finalize at Code Sprint, but
seems I won't get much time for random hacking before Summit.
Thus this post.

--
marko

Attachment Content-Type Size
README.txid.txt text/plain 2.2 KB
txid.tgz application/x-gzip 7.4 KB

Browse pgsql-hackers by date

  From Date Subject
Next Message Marc Munro 2006-06-30 22:02:45 Re: Index corruption
Previous Message Tom Lane 2006-06-30 17:59:26 Re: Fixed length datatypes. WAS [GENERAL] UUID's as