Philip McClarence·Aug 20Aurora PostgreSQL Storage Model: What Actually ChangesThe pager that taught me Aurora isn’t Postgres
Philip McClarence·Aug 20The Moment I Stopped Assuming DELETE Meant DeletedPostgres never deletes rows in place — it marks them dead and lets autovacuum reclaim the space later, update statistics, and freeze old…
Philip McClarence·Aug 10Five schema decisions that cost me sleep (and eventually a late‑night page)They aren’t bugs. They pass code review. They look perfectly reasonable when you’re staring at a CREATE TABLE statement on a Wednesday…
Philip McClarence·Aug 10Postgres Time-Series Partition Maintenance GuidePostgres time-series partition maintenance usually fails quietly: a cron job stops succeeding, nobody notices, and data piles into the…
Philip McClarence·Aug 8The psql Password Prompt You Never Set: It’s Not a Bug, It’s pg_hba.confYou install PostgreSQL, open a terminal, and run psql -U postgres. Instead of a prompt, you get:
Philip McClarence·Aug 8Five schema decisions that cost me sleep (and eventually a late‑night page)They aren’t bugs. They pass code review. They look perfectly reasonable when you’re staring at a CREATE TABLE statement on a Wednesday…
Philip McClarence·Aug 4Partition pruning isn’t a switch you flip onceI walk through this live in the companion video — but here’s the written deep dive, with the plans and the pain that got me paged at 3 a.m.A response icon1A response icon1
Philip McClarence·Aug 4Why Postgres DELETE Doesn’t Shrink Your TableThe ticket that started it: “I deleted 40 million rows and nothing happened”
Philip McClarence·Aug 3Zero Downtime Postgres Major Upgrade with Logical Replication: The Exact SequenceWhy pg_upgrade Wasn’t an OptionA response icon1A response icon1
Philip McClarence·Aug 3Postgres Transaction ID Wraparound: Full Recovery GuidePostgres will stop your writes to protect your data. Here’s the 32-bit clock behind it, and the three queries that tell you how much runway…