Re: Nested transactions: low level stuff

Поиск
Список
Период
Сортировка
От Mikheev, Vadim
Тема Re: Nested transactions: low level stuff
Дата
Msg-id 3705826352029646A3E91C53F7189E325187AD@sectorbase2.sectorbase.com
обсуждение исходный текст
Ответ на Nested transactions: low level stuff  (Manfred Koizar <mkoi-pg@aon.at>)
Список 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 по дате отправления:

Предыдущее
От: "Anand B Kumar"
Дата:
Сообщение: Please clarify with regard to Renaming a Sequence
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: [GENERAL] Please clarify with regard to Renaming a Sequence