Learn PostgreSQL

Build and manage high-performance database solutions using PostgreSQL 12 and 13

What is this book about?

PostgreSQL is one of the fastest-growing open source object-relational database management systems (DBMS) in the world. As well as being easy to use, it’s scalable and highly efficient. In this book, you’ll explore PostgreSQL 12 and 13 and learn how to build database solutions using it. Complete with hands-on tutorials, this guide will teach you how to achieve the right database design required for a reliable environment.

This book covers the following exciting features:

• Understand how users and connections are managed by running a PostgreSQL instance
• Interact with transaction boundaries using server-side programming
• Identify bottlenecks to maintain your database efficiently
• Create and manage extensions to add new functionalities to your cluster
• Choose the best index type for each situation

Book Outline

The book is divided into five main parts. The following is a list of the book chapters.

Part 1: Getting Started

1. Introduction to PostgreSQL
2. Getting to know your cluster
3. Managing Users and Connections

Part 2: Interacting with the Database

4. Basic Statements
5. Advanced Statements
6. Window Functions
7. Server Side Programming
8. Triggers and Rules
9. Partitioning

Part 3: Adminstering the cluster

10. Users, Roles and Database Security
11. Transactions, MVCC, WALs and Checkpoints
12. Extending the database: the Extension ecosystem
13. Indexes and Performance Optimization
14. Logging and Auditing
15. Backup and Restore
16. Configuration and Monitoring

Part 4: Replication

17. Physical Replication
18. Logical Replication

Part 5: The PostgreSQL Ecosystem

19. Usefult tools and useful extensions
20. Towards PostgreSQL 13