Re: Nested transactions: low level stuff - Mailing list pgsql-hackers

From Mikheev, Vadim
Subject Re: Nested transactions: low level stuff
Date
Msg-id 3705826352029646A3E91C53F7189E325187AD@sectorbase2.sectorbase.com
Whole thread Raw
In response to Nested transactions: low level stuff  (Manfred Koizar <mkoi-pg@aon.at>)
List pgsql-hackers
> I see no concurrency problems.  If two or more backends visit the same
> tuple, they either write the same value to the same position which
> doesn't hurt, or one sees the other's changes which is a good thing.

AFAIR, on multi-CPU platforms it's possible that second transaction could
see COMMITTED state but still old (subtrans id) in xmin: it's not
guaranteed that changes made on CPU1 (V1 was changed first, then V2 was
changed) will appear at the same order on CPU2 (V2 may come first, then V1).

Vadim


_____________________________________________________
Revere Data, LLC, formerly known as Sector Data, LLC, is not affiliated with
Sector, Inc., or SIAC.


pgsql-hackers by date:

Previous
From: "Anand B Kumar"
Date:
Subject: Please clarify with regard to Renaming a Sequence
Next
From: Martijn van Oosterhout
Date:
Subject: Re: [GENERAL] Please clarify with regard to Renaming a Sequence