Skip to Content
PostgreSQL Administration Essentials
book

PostgreSQL Administration Essentials

by Hans-Jürgen Schönig
October 2014
Intermediate to advanced content levelIntermediate to advanced
142 pages
3h 9m
English
Packt Publishing
Content preview from PostgreSQL Administration Essentials

Chapter 2. Indexing and Performance Tuning

You might wonder why a book about PostgreSQL administration actually contains a chapter on indexing and performance tuning. The answer is quite simple actually; extensive experience in database engineering and support shows that a poor indexing strategy will, on a regular basis, totally cripple user experience as well as performance. It happens on a regular basis that a bad overall indexing strategy totally destroys user experience as well as performance.

Therefore, it is one of my primary goals to provide as much information as possible about hunting down wrong or missing indexes so that you, the reader, can easily optimize your system to enjoy the full power of PostgreSQL.

In this chapter, you will be ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

PostgreSQL 9 Administration Cookbook - Second Edition

PostgreSQL 9 Administration Cookbook - Second Edition

Simon Riggs, GIANNI CIOLLI, Hannu Krosing, Gabriele Bartolini

Publisher Resources

ISBN: 9781783988983