In addition to MVCC locking, one can control locking explicitly when MVCC does not provide a desirable behavior. Generally speaking, PostgreSQL provides three locking mechanisms, which are:
- Table-level locks
- Row-level locks
- Advisory locks
- Preface
- Relational Databases
- PostgreSQL in Action
- PostgreSQL Basic Building Blocks
- PostgreSQL Advanced Building Blocks
- SQL Language
- Advanced Query Writing
- Server-Side Programming with PL/pgSQL
- OLAP and Data Warehousing
- Beyond Conventional Data Types
- Transactions and Concurrency Control
- PostgreSQL Security
- The PostgreSQL Catalog
- Optimizing Database Performance
- Testing
- Using PostgreSQL in Python Applications
- Scalability
Explicit locking
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.