Book
PostgreSQL徹底入門 第4版
近藤雄太, 正野裕大, 坂井潔, 鳥越淳, 笠原辰仁, 石井達夫
Summary
MVCC・VACUUM・共有バッファなど PostgreSQL の実装を深く知ることで、抽象的な DB 理論が 物理ハードウェア上でどう動くかの解像度を劇的に上げる代表的な実装書。 インストールから機能・仕組み、アプリ作り、管理・運用までを網羅し、追記型アーキテクチャや 分離レベルの物理的実態を掌握できる。
Target Readers
- PostgreSQL を本格的に運用したいエンジニア
- RDBMS の内部実装を具体的な製品で学びたい開発者
Tags
Colophon
- Publisher
- 翔泳社
- ISBN
- 978-4798160436
- Published
- Oct 2019
- List price
- ¥3,608incl. taxMay differ from the actual selling price on Amazon
Get this book
* The link above is an advertisement via Amazon Associates.Related Books
Prerequisites
- Recommended
SQLパフォーマンス詳解
Markus Winand
Reason: After grasping RDBMS-agnostic index theory in 'SQL Performance Explained', verify how it is implemented in a concrete product via the Japanese PostgreSQL book (PostgreSQL徹底入門). Touching PostgreSQL-specific index types—B-Tree, GiST, GIN, BRIN—and transaction mechanisms lands the abstract theory onto a concrete implementation.
Next Books
- Recommended
Database Internals
Alex Petrov
Reason: Once you understand one concrete RDBMS implementation (PostgreSQL), you want a map to put it in perspective. Petrov's 'Database Internals' systematizes storage engines and distributed implementations across products, letting you grasp where 'this PostgreSQL mechanism' sits in the general picture.
Sources
- Recommended
Database Reliability Engineering
Laine Campbell, Charity Majors
Reason: After covering the operational basics of PostgreSQL—backups, monitoring, transactions—the next stage is elevating them into organized, systematic operational discipline. 'Database Reliability Engineering' (by Laine Campbell and Charity Majors) applies the SRE principles systematized by Google to database operations, moving you from ad-hoc operations to SLO-based reliability design.
- Recommended
PostgreSQL実践入門
NTTオープンソースソフトウェアセンタ
Reason: After understanding PostgreSQL's internal implementation—MVCC, shared buffers—the next step is putting that knowledge to work in actual production operations. This book (PostgreSQL実践入門) covers replication, backup/restore, permission management, authentication and encryption, monitoring, and performance tuning, connecting internals knowledge to concrete operational procedures.
Sources
- Related
Designing Data-Intensive Applications
Martin Kleppmann
Reason: Once you understand operating and transactions on a single RDBMS (PostgreSQL), step into the distributed world of what breaks when you scale to multiple nodes. Kleppmann's 'Designing Data-Intensive Applications' covers replication and consistency trade-offs, bridging single-node operational knowledge into distributed design.