On 2020-11-02 09:26, Jürgen Purtz wrote:
OLD:
A first approach to implement protections against concurrent
access to the same data may be the locking of critical
rows. Two such techniques are:
<emphasis>Optimistic Concurrency Control</emphasis> (OCC)
and <emphasis>Two Phase Locking</emphasis> (2PL).
<productname>PostgreSQL</productname> implements a third, more
sophisticated technique: <firstterm>Multiversion Concurrency
Control</firstterm> (MVCC). The crucial advantage of MVCC ...
Proposal:
A first approach to implement protections against concurrent
access to the same data may be the locking of critical
rows.
<productname>PostgreSQL</productname> implements a more
sophisticated technique which avoids any locking:
<firstterm>Multiversion Concurrency
Control</firstterm> (MVCC). The crucial advantage of MVCC ...
Any thoughts or other suggestions?
Yes, just leave it out. Much better, as far as I'm concerned.
Erik
