- Mastering PostgreSQL 9.6
- Hans Jurgen Schonig
- 160字
- 2021-07-09 19:57:13
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.
- Mastering Mesos
- Python Artificial Intelligence Projects for Beginners
- 樂高機器人EV3設計指南:創造者的搭建邏輯
- 輕松學Java
- 來吧!帶你玩轉Excel VBA
- 人工智能實踐錄
- Windows安全指南
- 基于人工免疫原理的檢測系統模型及其應用
- Instant Slic3r
- Getting Started with Tableau 2018.x
- Learning iOS 8 for Enterprise
- 深度學習之模型優化:核心算法與案例實踐
- 單片機硬件接口電路及實例解析
- Hands-On Artificial Intelligence for Beginners
- 工業控制系統安全