PostgreSQL 9.6 High Performance

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

PostgreSQL 9.6 High Performance

Ibrar Ahmed, Gregory Smith

8 customer reviews
Enhance the performance of your PostgreSQL system with this handy guide while avoiding common pitfalls that can slow it down.
Packt Subscription
$5.00
$9.99/m after first month
eBook
$5.00
RRP $39.99
Save 87%
Print + eBook
$49.99
RRP $49.99
What do I get with a Packt subscription?
  • Exclusive monthly discount - no contract
  • Unlimited access to entire Packt library of 6500+ eBooks and Videos
  • 120 new titles added every month, on new and emerging tech
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
$5.00
$5.00
$49.99
$9.99/m after first month
RRP $39.99
RRP $49.99
Subscription
eBook
Print + eBook
Subscribe Now

Frequently bought together


PostgreSQL 9.6 High Performance Book Cover
PostgreSQL 9.6 High Performance
$ 39.99
$ 5.00
PostgreSQL Administration Cookbook, 9.5/9.6 Edition Book Cover
PostgreSQL Administration Cookbook, 9.5/9.6 Edition
$ 47.99
$ 5.00
Buy 2 for $10.00
Save $77.98
Add to Cart

Book Details

ISBN 139781784392970
Paperback508 pages

Book Description

Database administrators and developers spend years learning techniques to configure their PostgreSQL database servers for optimal performance, mostly when they encounter performance issues. Scalability and high availability of the database solution is equally important these days. This book will show you how to configure new database installations and optimize existing database server installations using PostgreSQL 9.6.

You will start with the basic concepts of database performance, because all successful database applications are destined to eventually run into issues when scaling up their performance. 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. Optimize your queries against the database with the help of right indexes, and monitor every layer, ranging from hardware to queries. Moving on, you will see how connection pooling, caching, partitioning, and replication will help you handle increasing database workloads.

Achieving high database performance is not easy, but you can learn it by using the right guide—PostgreSQL 9.6 High Performance.

Table of Contents

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 for best performance

Authors

Table of Contents

Book Details

ISBN 139781784392970
Paperback508 pages
Read More
From 8 reviews

Read More Reviews

Recommended for You

PostgreSQL Administration Cookbook, 9.5/9.6 Edition Book Cover
PostgreSQL Administration Cookbook, 9.5/9.6 Edition
$ 47.99
$ 5.00
Learning PostgreSQL 10 - Second Edition Book Cover
Learning PostgreSQL 10 - Second Edition
$ 27.99
$ 5.00
PostgreSQL High Availability Cookbook - Second Edition Book Cover
PostgreSQL High Availability Cookbook - Second Edition
$ 43.99
$ 5.00
PostgreSQL High Performance Cookbook Book Cover
PostgreSQL High Performance Cookbook
$ 43.99
$ 5.00
Mastering PostgreSQL 10 Book Cover
Mastering PostgreSQL 10
$ 31.99
$ 5.00
Linux: Powerful Server Administration Book Cover
Linux: Powerful Server Administration
$ 79.99
$ 5.00