PostgreSQL 18 Engineering: Internals, Execution, and Data Integrity at Scale

By Jacob Donnell

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 modelQuery planning and execution mechanicsConcurrency control and logical consistencyReplication and failover boundariesPartitioning as an execution strategyProduction 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.

• Format: Paperback
• Language: English
• ISBN: B0GQVCDYQC
• ISBN13: 9798250418065
• Release Date: March 2026
• Publisher: Independently Published
• Length: 198 Pages
• Weight: 1.04 lbs.
• Dimensions: 0.4" x 8.5" x 11.0"