PostgreSQL 9.6 High Performance

Key Features

• This book shows you the best practices to configure the PostgreSQL database for optimal performance
• Fine tune the performance of your queries using benchmarking and indexing techniques
• Ensure high performance and a highly available databases using the scaling and replication techniques

Book Description

This book starts with the basic concepts of database performance, because all successful database applications are destined to eventually run into issues when scaling up their performance. Therefore, you need to understand the basics of database performance.

In this book, you will not only learn to optimize your database and queries for optimal performance, but also detect the real performance bottlenecks using PostgreSQL tools and some external tools. Next, you will learn how to benchmark your hardware and tune your operating system.

You'll optimize queries against the database, with the right indexes. You'll monitor every layer, from hardware to queries. Some tools are inside PostgreSQL; others are external.

Using monitoring insights, you'll continuously rework the design and configuration. Once reaching the limits of a single server, you'll break things up. Moving on, connection pooling, caching, partitioning, and replication will all help you handle increasing database workloads.

Achieving high database performance is not easy, but you can learn it by using the right guide-this guide.

What you will learn

• Tune your database within your hardware and operating system limitations
• Make the right decision on the hardware for your database and application
• Discover how to make informed speed and reliability trade-offs
• Understand your operating system's parameters, which can help to improve your database performance
• Get to know the different techniques and tools to benchmark your databases and hardware
• Work with the PostgreSQL configuration parameters and use these parameters in real-world scenarios
• Write optimal queries and techniques to detect performance issue in queries