> IMMEDIATE TRANSACTION It has unfair properties, there is no lock queue and workers could starve forever trying to get lock in high contention context. It's v

> IMMEDIATE TRANSACTION It has unfair properties, there is no lock queue and workers could starve forever trying to get lock in high contention context. It's very easy to get busy timeout. You have to use external proper lock if you want to use IMMEDIATE mode. A peculiar thing: with external write lock (flock) you could get a true serializability without errors. IMPLICIT (default) transaction mode in other hand could be tricky to manage, because you could get integrity error on commit.