O'Reilly logo

PostgreSQL High Performance Cookbook by Dinesh Kumar, Chitij Chauhan

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

Combined indexes

In this recipe, we will be discussing how PostgreSQL combines multiple indexes to produce desired results.

Getting ready

When the query has a predicate with multiple columns and each column has associated with an index then the optimizer combines all the index results to fetch the desired results.

How to do it...

For demonstration, let's query the database as follows:

benchmarksql=# EXPLAIN SELECT * FROM bmsql_item WHERE i_data = 'Item Name' OR i_price = 3; QUERY PLAN ------------------------------------------------------------------------------------ Bitmap Heap Scan on bmsql_item (cost=8.82..60.67 rows=14 width=71) Recheck Cond: (((i_data)::text = 'Item Name'::text) OR (i_price = '3'::numeric)) -> BitmapOr (cost=8.82..8.82 rows=14 ...

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