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

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.
主站蜘蛛池模板: 荣成市| 磴口县| 崇信县| 绥棱县| 防城港市| 敦化市| 南华县| 阜新| 上虞市| 顺昌县| 崇州市| 天水市| 扎兰屯市| 福清市| 太仆寺旗| 维西| 大新县| 大安市| 卢湾区| 建瓯市| 天津市| 犍为县| 东乌| 安徽省| 沈阳市| 九龙城区| 屯昌县| 黄大仙区| 景德镇市| 宁陕县| 岢岚县| 调兵山市| 汤阴县| 门头沟区| 噶尔县| 广汉市| 昌乐县| 郑州市| 友谊县| 新竹县| 扎赉特旗|