Mastering PostgreSQL 12

Table of Contents

1. PostgreSQL 12 Overview
2. Understanding Transactions and Locking
3. Making Use of Indexes
4. Handling Advanced SQL
5. Log Files and System Statistics
6. Optimizing Queries for Good Performance
7. Writing Stored Procedures
8. Managing PostgreSQL Security
9. Handling Backup and Recovery
10. Making Sense of Backups and Replication
11. Deciding on Useful Extensions
12. Troubleshooting PostgreSQL
13. Migrating to PostgreSQL