Learn PostgreSQL - a new book
I’m really excited to introduce you to a new PostgreSQL book entitled Learn PostgreSQL, written by myself and my good friend Enrico.
The book covers PostgreSQL 12 and 13 and contains 20 chapters explaining how to install a cluster, how to set up for first connections, basic usage of SQL and data types, the administration of a cluster including role management, statistics and performances, log analysis and tuning, with a eye on backups. The last section of the book is dedicated to replication, both physical and logical.
It has been an hard word to complete the book, and I would like to thank Enrico for having written this with me. We are really proud and believe it delivers a good content and a complete presentation of our beloved database.
A quick book outline is the following one:
Part 1
- Introduction to PostgreSQL
- Getting to know your cluster
- Managing Users and Connections
Part 2
- Basic Statements
- Advanced Statements
- Window Functions
- Server Side Programming
- Triggers and Rules
- Partitioning
Part 3
- Users, Roles and Database Security
- Transactions, MVCC, WALs and Checkpoints
- Extending the database: the Extension ecosystem
- Indexes and Performance Optimization
- Logging and Auditing
- Backup and Restore
- Configuration and Monitoring
Part 4
- Physical Replication
- Logical Replication
Part 5
- Usefult tools and useful extensions
- Towards PostgreSQL 13
There is of course much more to describe about the book, but so far I’m still recovering from an eye surgery so I will come back in the following weeks to discuss the book.
In the meantime you can have a look at the official repository hosting the code examples.
Update and Fix Typos
I’m sorry, in the original post I have both mispelled the title, not placed the right image and link.This is what happens when you try to edit a post and your eyes have not recovered yet from the last surgery!
This is also why I recorded the video in first place!