Re: 32/64-bit transaction IDs? - Mailing list pgsql-general

From Tom Lane
Subject Re: 32/64-bit transaction IDs?
Date
Msg-id 1997.1048357741@sss.pgh.pa.us
Whole thread Raw
In response to Re: 32/64-bit transaction IDs?  ("Ed L." <pgsql@bluepolka.net>)
Responses Re: 32/64-bit transaction IDs?  ("Ed L." <pgsql@bluepolka.net>)
List pgsql-general
"Ed L." <pgsql@bluepolka.net> writes:
> Actually, dbmirror does it in a couple of steps, but I think this is the
> basic idea.  So the queued tuple changes are groupable (and thus
> replayable) by xid and order of queueing.  Then the slave gets them in the
> hopefully-correct order via
>     select ...
>     from queue q
>     where q.xid is in some appropriate range
>     order by xid asc, tuple_id asc;

I think this last part is wrong.  It shouldn't be using the xid as part
of the ordering, only the sequence value.

            regards, tom lane


pgsql-general by date:

Previous
From: "Ed L."
Date:
Subject: Re: 32/64-bit transaction IDs?
Next
From: "Ed L."
Date:
Subject: Re: 32/64-bit transaction IDs?