[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_28":-5,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_51":52,"_53":54,"_55":56,"_57":58},"routes/_store+/_readers+/email_author.$slug/route",{"_9":10,"_11":-5},"book",{"_12":13,"_14":15,"_16":17,"_18":19,"_20":21,"_22":23},"currentUser","id","Z2lkOi8vbGVhbnB1Yi9TdG9yZTo6Qm9va1Byb2R1Y3QvNzgyMjU","title","PostgreSQL From MVCC to Production","state","published","contactAuthorMethod","email","aboutText","

You already know how to write a join. You've run EXPLAIN. You've been on the wrong end of a deadlock at least once. And still, occasionally, Postgres wakes you up at three in the morning. Same code, same hardware, something changed, and you don't know what.

PostgreSQL: From MVCC to Production is the book that closes that gap. Not a feature tour. Not a reference. A focused, opinionated build-up of the mental model that makes everything else legible: how MVCC works and what it costs, why vacuum matters and when it falls behind, how the query planner makes decisions and how to disagree with it, what every connection actually owns, and how replication, failover, backups, and tuning fit together into a system you can reason about.

The book covers twenty-eight chapters across four parts. Part I lays the foundation: MVCC, storage, WAL, processes and memory, indexes from first principles. Part II is querying like an expert: plan shapes, index types, statistics, GIN, partial and expression indexes, concurrent operations. Part III is concurrency: row locking, MVCC contention, deadlocks, autovacuum, connection pooling with PgBouncer. Part IV operates Postgres at scale: streaming replication, logical replication, Patroni-based HA, pgBackRest backups, configuration tuning, capacity planning, and incident runbooks.

Every example runs against the cinetrack dataset, a movie-and-reviews schema with MovieLens 25M data, reproducible in a single docker-compose up. Pure SQL throughout. No framework code.

Targets Postgres 17. Written for senior engineers who want to stop discovering things the hard way.

","authors",[24],{"_12":25,"_26":27,"_28":29},"Z2lkOi8vbGVhbnB1Yi9TdG9yZTo6UHJvZHVjdEF1dGhvci84MzgwNQ","name","Umur Inan","user",{"_30":31},"avatar",{"_32":33,"_34":35,"_36":37},"url","https://d39qdlcrvnra4b.cloudfront.net/avatars/3702699/medium/avatar.jpg?1776450137","styleName","medium","exists",true,"shoppingCartId","shoppingCart",{"_12":71,"_72":73,"_74":37,"_75":76,"_77":78,"_79":80,"_81":37},"locale","en","readerTheme","light","constants",{"_69":70},"publishers",{"_65":66,"_67":68},"learnerOrganizations",[],"needsLocaleCookieSync",false,"announcements",{"_59":60,"_61":-5},"sentryEnvironment","production","sentryRelease","660879bd1b39a24c7d76a108e4c4fa14e02ebd8c","announcement_store",{"_62":52,"_63":64},"announcement_authors","flag","text","

Kick off your book project, get started with GhostAI, get better at marketing, or spend the day doing all three! Free live workshops on Zoom. Saturday, June 27, 2026.

\n","companies",[],"universities",[],"paypalClientId","AX53Cwz8jR6rVVzzZiZNWWXl0dGagi-GZrjG-S3Ua14E5nrKMn7DxDQ730O4R8LusLPp49ALn6aRVaEy","no-cart","count",0,"free","updatedAt","","paymentGateway","STRIPE","cartItems",[],"loading"]

Email the Author