Overview

What really happens inside PostgreSQL when a query leaves your application and enters the server?18 How does it remain consistent under heavy concurrency? What protects your data when systems fail, scale, or recover? PostgreSQL 18 Engineering: Internals, Execution, and Data Integrity at Scale by Jacob Donnell is written for engineers who want more than surface knowledge. This book speaks directly to those running PostgreSQL in real production environments-where performance, correctness, and predictability are not optional. Do you understand how queries are planned and executed? How multi-version concurrency control preserves consistency? How write-ahead logging guarantees durability? Why certain architectural decisions prevent shortcuts that could compromise integrity? This is not a beginner's guide. It is a deep, practical conversation about how PostgreSQL truly works. Inside, you'll explore: Internal architecture and process model Query planning and execution mechanics Concurrency control and logical consistency Replication and failover boundaries Partitioning as an execution strategy Production scaling and operational trade-offs Every chapter challenges you to think like a systems engineer, not just a database user. It asks the questions most teams only confront during incidents-and answers them before they become failures. If you depend on PostgreSQL for serious workloads, ask yourself: Are you simply using it... or are you engineering with it? Build systems that scale without breaking guarantees. Strengthen your understanding. Take control of the internals. Get your copy today and start designing PostgreSQL systems with confidence.

Full Product Details

9798250418065

Table of Contents

Reviews

Author Information

Tab Content 6

Countries Available