Re: Question on SSI - Serializable Snapshot Isolation

2023-04-18 Thread Siddharth Jain
ok thanks tom. On Mon, Apr 17, 2023 at 2:39 PM Tom Lane wrote: > Siddharth Jain writes: > > 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 doo

Re: Question on SSI - Serializable Snapshot Isolation

2023-04-17 Thread Tom Lane
Siddharth Jain writes: > 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: image.png] Please don't use images for things that co

Question on SSI - Serializable Snapshot Isolation

2023-04-17 Thread Siddharth Jain
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: image.png] but will not raise serialization error until the transaction commi