The Art of PostgreSQL: a PostgreSQL book for developers in 2026Get the Book – $89
Buy the Book<br>See What's New
Write production-grade SQL<br>Turn complex application logic into efficient, scalable SQL<br>queries that run fast in real systems.
Write efficient SQL by design<br>Build queries that perform well naturally by leveraging proper<br>schema design, relational modeling, and PostgreSQL advanced<br>features.
Design schemas that scale<br>Model data and relationships that hold up under growth, load, and<br>real-world constraints.
Browse the full table of contents →
"This book is on a higher level than generic software books. It explains the how's and why's of using Postgres's many feature. It is an excellent companion to the official Postgres documentation."<br>Bruce Momjian, PostgreSQL core team
"At last the definitive Postgres book for app developers is out, and from the amazing @tapoueh no less. Go get it!"<br>Peter van Hardenberg
"Full edition of The Art of PostgreSQL is BRILLIANT! Not just best PG resource ever but best tech-learning package I've ever seen!"<br>Derek Sivers
"Thanks for your fantastic book. It's helped me immensely in my current job. Technical books can often be a bore and hard to digest, but The Art of PostgreSQL was a pleasure to read."<br>Ben Davies
Get the Book
The book is your entry point to a complete PostgreSQL system. Learn<br>the fundamentals, practice with real data, then apply advanced<br>techniques in production.<br>MOST POPULAR<br>Digital Edition<br>$89<br>You get the complete book with practical SQL techniques,<br>real-world examples, and datasets to follow along and<br>experiment.<br>Start here to build solid foundations, then continue with the<br>Course and Workshop to deepen your expertise.<br>The online edition includes everything you need to work<br>hands-on: the datasets and all queries are provided as separate<br>SQL files, so you can run, modify, and experiment locally. It<br>also connects directly with the companion lab on GitHub.<br>Money-back guarantee<br>No-questions-asked refund
Get the Book
PAPERBACK<br>Paperback Edition<br>$129<br>Get a physical copy of the book to read, annotate, and keep at<br>hand while you work. The paperback is designed to be a practical<br>companion—something you can open next to your editor or database<br>console as you apply the concepts.<br>It includes the full digital edition as well, so you can switch<br>seamlessly between reading on screen and working through<br>examples locally. Same content, different format—choose what<br>fits your workflow best.<br>Money-back guarantee<br>No-questions-asked refund
Get the Paperback
Fair Pricing Available
Written by a PostgreSQL major contributor—author of CREATE EXTENSION<br>and Event Triggers—and creator of tools such as pgloader, pgcopydb,<br>and pg_auto_failover. With years of production consulting and<br>international conference speaking experience, the content is built for<br>developers who need practical, real-world skills, not theory.
Practical Skills That Still Apply<br>The Second Edition, Updated (2026) covers PostgreSQL 10 through 18 —<br>the core architecture, query optimization strategies, indexing<br>approaches, and data modeling practices are all current.<br>The course and workshop cover current PostgreSQL releases.
SQL Doesn't Expire<br>The core of what you'll learn — window functions, CTEs,<br>aggregates, indexing strategy, normalization, concurrency,<br>extensions — is as relevant in PostgreSQL 17/18 as it was in<br>PostgreSQL 11. SQL doesn't expire.<br>Where newer versions have introduced improvements (partitioning,<br>logical replication, generated columns, improved EXPLAIN), the<br>concepts taught here give you exactly the foundation needed to<br>understand and use those features.<br>This is not a book about PostgreSQL version X — it's a book about<br>thinking in SQL.
Always Up to Date<br>The Second Edition, Updated (2026) is now available — covering<br>PostgreSQL 10 through 18, with a new chapter on vector search with<br>pgvector, 56 new figures, and a fully integrated companion lab.<br>Everyone who purchases receives all future updates free of charge.
The Art of PostgreSQL: A Complete Learning System<br>Learn SQL, performance, and data modeling that works in production<br>The Art of PostgreSQL is a complete, practical system to move from<br>writing queries to designing and operating real data systems. Start<br>with the book to build solid foundations, then go deeper with<br>structured courses, use the lab for hands-on practice, and register to<br>expert-led workshops.<br>Get the Book
Core<br>Solid SQL foundations — correctness, clarity, essential patterns.
Advanced<br>Performance mastery — query plans, optimization, indexing.
Architect<br>System design — schemas, scaling, production decisions.
Go Beyond the Book
Workshops cover specific topics in depth — window functions, EXPLAIN plans, aggregation patterns, and more.<br>Limited seats, expert instruction, immediate application.<br>Join a Workshop
Run docker compose up -d and you're done. A pre-seeded<br>PostgreSQL instance starts with all the book's real-world datasets<br>already loaded — NYSE trading data, music...