Postgres in Depth
The database you will actually be using — its index types, its JSON support, and the two operational failures that bite everyone.
7 topics
Postgres Index Types
B-tree, GIN, GiST, BRIN and hash — what each one is for, and the three you will actually reach for.
core25 minJSONB & Semi-Structured Data
When a JSONB column is the right modelling choice, and the discipline that stops it becoming a schema-shaped landfill.
core20 minConnection Pooling
Why a Postgres connection is expensive, and why serverless functions break the usual assumptions about pooling.
core20 minVacuum, Bloat & Autovacuum
The cleanup process MVCC makes necessary — and the two ways teams accidentally stop it from running.
core20 minRow-Level Security
Pushing tenant and ownership rules into the database as policies, and the ways that goes wrong.
deep20 minDiagnosing a Slow Postgres
A repeatable order of operations for "the database is slow" — from pg_stat_statements down to the single bad plan.
core25 minCaching Strategies
The read/write patterns behind every cache, and the consistency you trade away for each.
core25 minshared