November 30
PostgreSQL offers multiple index types, each optimized for different query patterns and data shapes. Understanding which one to use is one of the highest-ROI skills in database engineering.
November 24
The Pagila sample database is a popular PostgreSQL training database modeled after a movie rental store. It includes tables for films, actors, customers, rentals, staff, payments, and more. This makes it perfect for learning PostgreSQL!
I’ve spent over 20 years optimizing databases and designing rock-solid data systems. Now I’m sharing what I’ve learned to help others build faster, smarter, and more reliable platforms.
