O'Reilly logo

Troubleshooting PostgreSQL by Hans-Jürgen Schönig

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 3. Handling Indexes

In this chapter, one of the most important topics in the area of database work will be covered—indexing. In many cases, missing or wrong indexes are the main source of trouble, leading to bad performance, unexpected behavior, and a great deal of frustration. To avoid these issues, this chapter will present all the information that you need to make your life as easy as possible.

The following issues will be covered:

  • Understanding PostgreSQL indexing
  • Types of indexes
  • Managing operator classes
  • Detecting missing indexes
  • Reading execution plans
  • Fixing LIKE
  • Fixing regular expressions
  • Improving indexes and functions
  • Indexes and insertions
  • Indexes and foreign keys

Understanding indexes in PostgreSQL

In this section, you will learn the fundamental ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required