EPUB

Read Online 15.2 MB Download

Enhance the performance of your PostgreSQL system with this handy guide while avoiding common pitfalls that can slow it down.

About This Book

Learn the right techniques to obtain optimal PostgreSQL database performance, ranging from initial design to routine maintenance

Fine tune the performance of your queries and avoid the common pitfalls that can slow your system down

Contains tips and tricks on scaling successful database installations, and ensuring a highly available PostgreSQL solution

Who This Book Is For

This 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 Learn

Learn the best practices to configure your PostgreSQL 9.6 database for optimal performance

Write optimal queries and techniques to detect performance issue in queries

Fine tune the performance of your queries using benchmarking and indexing techniques

Ensure high performance and a highly available database using the scaling and replication techniques

Discover how to make informed speed and reliability trade-offs

Handle increasing database workloads without any hassle

Use monitoring insights to continuously rework the design and configuration