Book
PostgreSQL Tettei Nyumon, 4th Edition (A Thorough Introduction to PostgreSQL)
From Installation to Features and Internals, Application Building, and Administration and Operations
Yuta Kondo, Yuta Masano, Kiyoshi Sakai, Tatsuhito Kasahara, Tatsuo Ishii, et al.
Summary
A Japanese-language introduction to PostgreSQL, in its 4th edition, by Yuta Kondo, Yuta Masano, Kiyoshi Sakai, Tatsuhito Kasahara, Tatsuo Ishii, et al. PostgreSQL is an open-source relational database management system that runs on UNIX-like operating systems such as Linux and macOS as well as on Windows. The book is for people who are new to PostgreSQL or to databases, and for those who have used it a little and want to know it in more detail. The 4th edition is fully revised on the basis of PostgreSQL 11 and selects the points that beginners should grasp as basics, old and new. Authors who are deeply involved with PostgreSQL in their daily work explain installation, the use of SQL, application building, and operation and also cover logical replication and parallel query. The book also deals with implementation topics such as MVCC, VACUUM, and shared buffers.
Target Readers
- People who are new to PostgreSQL, or new to databases altogether
- People who have used PostgreSQL a little and want to know it in more detail
- Engineers who want to operate PostgreSQL in earnest, and developers who want to learn the internal implementation of an RDBMS through a specific product
Tags
Colophon
- Publisher
- Shoeisha
- 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 Performance Explained
Everything Developers Need to Know about SQL Performance
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. 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
A Deep Dive into How Distributed Data Systems Work
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.
- Recommended
Database Reliability Engineering
Designing and Operating Resilient Database Systems
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 Jissen Nyumon (A Practical Introduction to PostgreSQL)
Architecture, Operations Monitoring, and Performance Improvement
NTT Open Source Software Center
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 covers replication, backup/restore, permission management, authentication and encryption, monitoring, and performance tuning, connecting internals knowledge to concrete operational procedures.
- Related
Designing Data-Intensive Applications
The Big Ideas Behind Reliable, Scalable, and Maintainable Systems
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.