Re: Additional Chapter for Tutorial
От | Erik Rijkers |
---|---|
Тема | Re: Additional Chapter for Tutorial |
Дата | |
Msg-id | 759f7a615736d8066b3441571d371c68@xs4all.nl обсуждение исходный текст |
Ответ на | Re: Additional Chapter for Tutorial (Jürgen Purtz <juergen@purtz.de>) |
Ответы |
Re: Additional Chapter for Tutorial
|
Список | pgsql-hackers |
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
В списке pgsql-hackers по дате отправления: