Re: Exposing the Xact commit order to the user - Mailing list pgsql-hackers

From Jan Wieck
Subject Re: Exposing the Xact commit order to the user
Date
Msg-id 4BFD865B.90406@Yahoo.com
Whole thread Raw
In response to Re: Exposing the Xact commit order to the user  (Dimitri Fontaine <dfontaine@hi-media.com>)
List pgsql-hackers
On 5/26/2010 4:11 PM, Dimitri Fontaine wrote:
> So even ordering the txid and txid_snapshots with respect to WAL commit
> time (LSN) won't be the whole story, for any given transaction
> containing more than one event we also need to have them in order. I
> know Jan didn't forget about it so it must either be in the proposal or
> easily derived, too tired to recheck.

No, that detail is actually not explained in the proposal. When applying 
all changes in transaction commit order, there is no need for a global 
sequence. A local counter per backend is sufficient because the total 
order of <xact-commit-order>, <local-xact-seq> yields a similarly 
agreeable order of actions.


Jan

-- 
Anyone who trades liberty for security deserves neither
liberty nor security. -- Benjamin Franklin


pgsql-hackers by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Exposing the Xact commit order to the user
Next
From: Peter Eisentraut
Date:
Subject: functional call named notation clashes with SQL feature