Book
PostgreSQL Jissen Nyumon (A Practical Introduction to PostgreSQL)
Architecture, Operations Monitoring, and Performance Improvement
NTT Open Source Software Center
Summary
A Japanese-language practical guide to PostgreSQL by members of the NTT Open Source Software Center, who are engaged in PostgreSQL research and development, including work on PostgreSQL itself and its surrounding tools. Starting from basic concepts, it covers the knowledge needed to run PostgreSQL in production: its internal process structure and query processing, table design, replication, user privilege management, login authentication and encryption, backup and restore, and monitoring. Performance tuning is also covered, using actual queries as examples. The book touches on the new features of PostgreSQL 18 and on configuration differences from older versions.
Target Readers
- DBAs who operate PostgreSQL in the field and want to cover replication, authentication, backup, restore, and monitoring
- Web developers who use PostgreSQL in the field and want to understand its internal process structure and query processing
- Developers who want to work on performance improvement and follow tuning examples built on actual queries
Tags
Colophon
- Publisher
- Gijutsu-Hyohron
- ISBN
- 978-4-297-14861-4
- Published
- Feb 2026
- List price
- ¥4,180incl. 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
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.
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.
Next Books
- Recommended
Database Reliability Engineering
Designing and Operating Resilient Database Systems
Laine Campbell, Charity Majors
Reason: After acquiring hands-on operational procedures for a single product—replication, backup/restore, monitoring, performance tuning—you will want to place them within an organizational reliability framework. 'Database Reliability Engineering' covers SLO-based risk management and zero-downtime migration, offering a lens to re-situate individual operational techniques within SRE principles.