Re: 32/64-bit transaction IDs?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: 32/64-bit transaction IDs?
Date: 2003-03-21 18:53:36
Message-ID: 14547.1048272816@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Ed L." <pgsql(at)bluepolka(dot)net> writes:
>> XIDs are issued in transaction start order, not transaction commit
>> order. Dunno if that's what's concerning you.

> Yes, I'm interested in any reliable ordering of transaction commits for the
> purpose of serial asyncronous replication. Is that possible?

The order in which commit records are inserted into the WAL log would
work (and if you just need an ID number, the commit records' WAL-log
addresses are 64-bits and would serve nicely). But you'll have to add
code to the backend to get at that.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-03-21 19:30:36 Re: another problem with pgsql and interva/timestamp
Previous Message Fernando Schapachnik 2003-03-21 18:49:39 Re: Posts get losts