Zero-downtime migrations in Postgres
Six rules for changing a schema while a thousand queries a second keep running.
#Databases
PostgreSQL in production: indexes, plans and safe changes.
3 postsReading EXPLAIN ANALYZE like a story Paid
Each line is a step, the steps nest and the numbers say where the time went.
Postgres indexes: the five you actually need
B-tree, multi-column, partial, covering and expression indexes, and how to check that each one works.