PostgreSQL 96 High Performance Author:Ibrar Ahmed, Gregory Smith Enhance the performance of your PostgreSQL system with this handy guide while avoiding common pitfalls that can slow it down.About This BookLearn the right techniques to obtain optimal PostgreSQL database performance, ranging from initial design to routine maintenanceFine tune the performance of your queries and avoid the common pitfalls that ca... more »n slow your system downContains tips and tricks on scaling successful database installations, and ensuring a highly available PostgreSQL solutionWho This Book Is ForThis book is for intermediate to advanced database administrators and developers who use or plan to exploit the features of PostgreSQL in the best possible manner. While administrators can benefit from the topics related to the installation, configuration, and optimization of the server, developers will learn how to write optimal queries and address performance issues in their database design. This book will also benefit the PostgreSQL internal architects in being able to monitor the performance using benchmarking tools.What You Will LearnLearn the best practices to configure your PostgreSQL 9.6 database for optimal performanceWrite optimal queries and techniques to detect performance issue in queriesFine tune the performance of your queries using benchmarking and indexing techniquesEnsure high performance and a highly available database using the scaling and replication techniquesDiscover how to make informed speed and reliability trade-offsHandle increasing database workloads without any hassleUse monitoring insights to continuously rework the design and configuration« less