Practical use of isolation level seralization?

Question

In which scenarios do we use the SERIALIZABLE Isolation level? I saw several answers on a website saying that if you want to completely isolate a transaction, we usually go for it.

What I would like to know from my own experience is that when you used it in your projects / or you saw how it can be used in other projects, and what is the specific requirement that other isolation levels have not been met?

Answer 1

SERIALIZABLE Useful for creating complex reports that require multiple queries.

READ COMMITTED REPEATABLE READ , .

pg_dump, dump PostgreSQL, SET TRANSACTION ISOLATION LEVEL SERIALIZABLE, , , , .

Answer 2

, . SQL ( SQL-92) , - () , , , , , .

- , , , , . . , , , , , , .

(S2PL), , , . concurrency (OCC). " " , . , , SQL. , Serializable Snapshot Isolation (SerializableSI SSI), , 2008 ACM SIGMOD, PostgreSQL 9.1 . , , . , . , .