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.

Learn PostgreSQL book cover




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!

Update 2 (2020-11-02)

Hans-Jürgen Schönig also wrote me to emphasize the mispelling in the title, apparently the Planet PostgreSQL is not getting an update of my post.

The article Learn PostgreSQL - a new book has been posted by Luca Ferrari on October 28, 2020