From: | "Andrey V(dot) Lepikhov" <a(dot)lepikhov(at)postgrespro(dot)ru> |
---|---|
To: | "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>, PostgreSQL-Dev <pgsql-hackers(at)postgresql(dot)org> |
Cc: | 'Fujii Masao' <masao(dot)fujii(at)oss(dot)nttdata(dot)com>, Masahiko Sawada <masahiko(dot)sawada(at)2ndquadrant(dot)com>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, "movead(dot)li(at)highgo(dot)ca" <movead(dot)li(at)highgo(dot)ca> |
Subject: | Re: Global snapshots |
Date: | 2021-02-26 06:20:49 |
Message-ID: | a0503174-9ac9-fe2c-1788-1a1337d72453@postgrespro.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 1/1/21 8:14 AM, tsunakawa(dot)takay(at)fujitsu(dot)com wrote:
> --------------------------------------------------
> 11. A method comprising:
> receiving information relating to a distributed database transaction operating on data in data stores associated with respective participating nodes associated with the distributed database transaction;
> requesting commit time votes from the respective participating nodes, the commit time votes reflecting local clock values of the respective participating nodes;
> receiving the commit time votes from the respective participating nodes in response to the requesting;
> computing a global commit timestamp for the distributed database transaction based at least in part on the commit time votes, the global commit timestamp reflecting a maximum value of the commit time votes received from the respective participating nodes; and
> synchronizing commitment of the distributed database transaction at the respective participating nodes to the global commit timestamp,
> wherein at least the computing is performed by a computing device.
Thank you for this analysis of the patent.
After researching in depth, I think this is the real problem.
My idea was that we are not using real clocks, we only use clock ticks
to measure time intervals. It can also be interpreted as a kind of clock.
That we can do:
1. Use global clocks at the start of transaction.
2. Use CSN-based snapshot as a machinery and create an extension to
allow user defined commit protocols.
--
regards,
Andrey Lepikhov
Postgres Professional
From | Date | Subject | |
---|---|---|---|
Next Message | tsunakawa.takay@fujitsu.com | 2021-02-26 06:21:15 | RE: libpq debug log |
Previous Message | Thomas Munro | 2021-02-26 06:08:12 | Replace buffer I/O locks with condition variables (reviving an old patch) |