Mastering PostgreSQL 15 : advanced techniques to build and manage scalable, reliable, and fault-tolerant database applications /
Hans-Jürgen Schönig.
- 5th edition.
- xi, 503 pages ; 24 cm.
Includes index.
PostgreSQL 15 overview -- Understanding transactions and locking -- Making use of indexes -- Handling advanced SQL -- Log files and system statistics -- Optimizing queries for good performance -- Writing stored procedures -- Managing PostgreSQL security -- Handling backup recovery -- Making sense of backups and replication -- Deciding on useful extensions -- Troubleshooting PostgreSQL -- Migrating to PostgreSQL.
"Updated to keep up with the latest version of PostgreSQL, this fifth edition will help you build dynamic database solutions for enterprise applications using real-world hands-on examples, enabling you to design both the physical and technical aspects of the system architecture with ease."