Materialized Views in the Real World: Designing for FAST Refresh & Query Rewrite (and what breaks) If your dashboard is…
Read More
JSONB Without Regret
JSONB Without Regret: When to Model vs Index Paths Decision tree + costed examples for PostgreSQL engineers Introduction — the…
Read More
Query Plans that Don’t Lie
Query Plans that Don’t Lie: Building a Performance Review with pg_stat_statements Hook: Your app got slower after the last release,…
Read MoreLogical vs Physical Replication in PostgreSQL
Logical vs Physical Replication in PostgreSQL: Blue/Green, Zero-Downtime Upgrades, and Read Scaling (with Real Cutover Runbooks) Ever scheduled a “maintenance…
Read MoreElastic Pools for Multi-Tenant SaaS
Elastic Pools for Multi-Tenant SaaS: Sizing, Noisy Neighbor Control, and Automation Why this matters (hook) Your SaaS just onboarded three…
Read More
