This updated fourth edition of Mastering PostgreSQL 13 will help you understand PostgreSQL administration and build dynamic database solutions for enterprise apps with the latest release of PostgreSQL, teaching you how to design both physical and technical aspects of system architecture with ease.
Starting with an introduction to the newly released features in PostgreSQL 13, this book will help you build efficient and fault-tolerant PostgreSQL apps. You'll also delve into advanced PostgreSQL features, including logical replication, database clusters, performance tuning, advanced indexing, monitoring, and user management, to manage and maintain your database. You will then work with the PostgreSQL optimizer, configure PostgreSQL for high speed, and move from Oracle to PostgreSQL. After that, you'll cover transactions, locking, and indexes, and learn how to perform query optimization for improved performance. Later, you'll focus on how to manage network security, and delve into backup and replication while exploring useful PostgreSQL extensions to help you optimize the performance of large databases.
By the end of this book, you'll be able to get the most out of your database by performing advanced administrative tasks.
