官术网_书友最值得收藏!

Considering SSI transactions

On top of read committed and repeatable read, PostgreSQL offers serializable (or SSI) transactions. So, in all, PostgreSQL supports three isolation levels. Note that read uncommitted (which still happens to be the default in some commercial databases) is not supported: if you try to start a read uncommitted transaction, PostgreSQL will silently map to read committed. However, back to serializable.

The idea behind serializable is simple; if a transaction is known to work correctly if there is only a single user, it will also work in the case of concurrency if this isolation level is chosen. However, users have to be prepared; transactions may fail (by design) and error-out. In addition to that, a performance penalty has to be paid.

If you want to know more about this isolation level, consider checking out https://wiki.postgresql.org/wiki/Serializable.

Consider using serializable only when you have a decent understanding of what is going on inside the database engine.
主站蜘蛛池模板: 潮州市| 手机| 定州市| 四川省| 永福县| 枣阳市| 康马县| 石首市| 宝坻区| 九台市| 旬阳县| 定安县| 衡阳市| 玛沁县| 岳西县| 海伦市| 荥阳市| 疏勒县| 通河县| 新野县| 彭山县| 夏河县| 辽中县| 昌乐县| 黎川县| 抚远县| 嘉定区| 厦门市| 南安市| 四子王旗| 临西县| 炉霍县| 于都县| 古田县| 女性| 太康县| 乐清市| 肃南| 通海县| 建德市| 富顺县|