Question on SSI - Serializable Snapshot Isolation

Поиск
Список
Период
Сортировка
От Siddharth Jain
Тема Question on SSI - Serializable Snapshot Isolation
Дата
Msg-id CAPqV3pTLaijfRegcKXkhqXnFVxWxXR7sSmDvbXFts_cn+bmquQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Question on SSI - Serializable Snapshot Isolation  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hi All,

When using SSI, lets say we have two transactions T1 and T2 and there is a serialization conflict. Postgres knows when one or the other transaction is doomed to fail 
image.png
but will not raise serialization error until the transaction commits. This can cause a massive perf hit because the transactions could be long running. Why not raise the error early on when the conflict is detected to avoid wasting CPU and other resources? Can anyone explain this to me? Is this an area that could be improved upon? Thanks.

S.
Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Ron
Дата:
Сообщение: Re: Suppress logging of "pg_hba.conf rejects connection for host"
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: Should I add a new schema for my application?