Section 2: Advanced Concepts

This section expands upon the key topics of PostgreSQL 12.

This section contains the following chapters:

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