PostgreSQL Guides

Some topics don't fit in a single post. Guides collect the multi-part series in reading order, so you can start at chapter one and work through, or jump to the part you need.

Guide

PostgreSQL Storage Internals

Seven chapters on the storage layer, in reading order. Pages move through shared buffers, rows become tuples, MVCC keeps the old versions, HOT updates dodge the index tax, TOAST takes what doesn't fit, and VACUUM reclaims the rest. Live pageinspect sessions throughout, with an interactive visualizer for most chapters.

Introduction to Buffers in PostgreSQL
Reading Buffer statistics in EXPLAIN output
Inside PostgreSQL's 8KB Page
PostgreSQL MVCC, Byte by Byte
HOT Updates in Postgres
TOAST: Where PostgreSQL hides big values
VACUUM at the Page Level

7 chapters · 88 min total

Guide

Mastering Logical Replication in PostgreSQL

Logical replication from first setup to production use. Publishers, subscribers, and row-level streaming, then the operational side: monitoring, data copy strategies, logical decoding, and publication control. Four more chapters are planned, from conflict resolution to zero-downtime major version upgrades.

First steps with Logical Replication in PostgreSQL
Beyond the Basics of Logical Replication
Conflict Resolution, Performance, and Advanced Topologies soon
Zero-Downtime Major PostgreSQL Version Upgrades soon
Blue/Green Schema Migrations with Logical Replication soon
Real-Time Change Data Capture (CDC) soon

6 chapters planned · 2 published · 24 min so far

Guide

PostgREST Tutorial: APIs made easy

Three-part tutorial building a Time Off Manager API on PostgREST. Expose tables as endpoints, add business logic with views and stored procedures, then lock the API down with JWT authentication and row-level security. No application server, no boilerplate.

Deep Dive into PostgREST - Time Off Manager (Part 1)
Deep Dive into PostgREST - Time Off Manager (Part 2)
Deep Dive into PostgREST - Time Off Manager (Part 3)

3 chapters · 25 min total