TY - BOOK AU - Schönig,Hans-Jürgen TI - Mastering PostgreSQL 15: advanced techniques to build and manage scalable, reliable, and fault-tolerant database applications SN - 9781803248349 AV - QA76.73.S67 .S366 2023 U1 - 005.756 23 PY - 2023/// CY - Birmingham, UK : PB - Packt Publishing, KW - SQL (Computer program language) KW - PostgreSQL N1 - 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. N2 - "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." ER -