Re: Global snapshots - Mailing list pgsql-hackers

From Masahiko Sawada
Subject Re: Global snapshots
Date
Msg-id CAD21AoBph=12dbyH6KJJ--UkBKtzugT3iJb8CPL5fY7tdpLW8g@mail.gmail.com
Whole thread Raw
In response to Global snapshots  (Stas Kelvich <s.kelvich@postgrespro.ru>)
Responses Re: Global snapshots  (Stas Kelvich <s.kelvich@postgrespro.ru>)
List pgsql-hackers
On Wed, May 2, 2018 at 1:27 AM, Stas Kelvich <s.kelvich@postgrespro.ru> wrote:
> 1) To achieve commit atomicity of different nodes intermediate step is
>    introduced: at first running transaction is marked as InDoubt on all nodes,
>    and only after that each node commit it and stamps with a given GlobalCSN.
>    All readers who ran into tuples of an InDoubt transaction should wait until
>    it ends and recheck visibility.

I'm concerned that long-running transaction could keep other
transactions waiting and then the system gets stuck. Can this happen?
and is there any workaround?

Regards,

--
Masahiko Sawada
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center


pgsql-hackers by date:

Previous
From: Liudmila Mantrova
Date:
Subject: Re: documentation is now XML
Next
From: Tom Lane
Date:
Subject: Re: Optimize Arm64 crc32c implementation in Postgresql