- Database Connection Pooling
Explains why a database connection is an expensive OS process, how connection pools work, and how to size a pool using Little's Law, Kingman's formula, and the process-to-core ratio.
- PostgreSQL HA Patroni Best Practices
Best practices for running highly available PostgreSQL with Patroni, PgBouncer, and etcd, including when to use the Ivory management UI versus the CLI.
- Zero-Downtime Database Migration
Michiel Rook's May 2019 expand and contract sequence for renaming a column while two application versions share one database, and the locks, backfill races, and tool limits that sequence does not remove.