The default thresholds were sized for tables that don’t exist anymore. Here’s the math that actually scales — and the per-table overrides that fix it. →
PostgreSQL never modifies a row in place. Every UPDATE writes a new version and leaves the old one behind. Here’s the machinery — and why it explains half your performance problems. →
Having managed both at scale, the answer to ‘PostgreSQL or MongoDB for JSON?’ is not as simple as ‘MongoDB is for documents.’ Deep internals on both sides will affect your performance, storage footprint, and operational burden in ways a quick benchmark won’t reveal. →
Deep dive into PostgreSQL’s TOAST (The Oversized-Attribute Storage Technique) mechanism and how it works around the fundamental 8KB block size limitation. Learn when TOAST activates, how it stores large values, and the performance implications for your database design. →
A walkthrough of PostgreSQL’s extension ecosystem — what extensions are, how they work, and which ones you should know about for production databases. →
PostgreSQL Internals Mastery Volume I is now available—a comprehensive foundation covering PostgreSQL architecture, memory management, storage, transactions, and durability. Learn how PostgreSQL really works at a systems level. →
