In this chapter, we covered some more theory about transactions and their ACID properties, isolation levels, and how PostgreSQL's isolation levels map to SQL standards. We covered the basics of PostgreSQL's MVCC. Along the way, we also had a look at a few system functions and columns that can be used both to understand the theory and to study system behavior in real life. In the next couple of chapters, we will focus on tools, one that can be used to design a database for PostgreSQL and another that can be used to work with the PostgreSQL cluster.
PostgreSQL for Data Architects
By :
PostgreSQL for Data Architects
By:
Overview of this book
Table of Contents (19 chapters)
PostgreSQL for Data Architects
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Free Chapter
Installing PostgreSQL
Server Architecture
PostgreSQL – Object Hierarchy and Roles
Working with Transactions
Data Modeling with SQL Power Architect
Client Tools
SQL Tuning
Server Tuning
Tools to Move Data in and out of PostgreSQL
Scaling, Replication, and Backup and Recovery
PostgreSQL – Troubleshooting
PostgreSQL – Extras
Index
Customer Reviews