PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries

© Henrietta Dombrovskaya, Boris Novikov, Anna Bailliekova 2021

H. Dombrovskaya et al.PostgreSQL Query Optimizationhttps://doi.org/10.1007/978-1-4842-6885-8_14

14. More Complex Filtering and Search

Henrietta Dombrovskaya¹  , Boris Novikov² and Anna Bailliekova³

(1)

Braviant Holdings, Chicago, IL, USA

(2)

HSE University, Saint Petersburg, Russia

(3)

Zendesk, Madison, WI, USA

 

Previous chapters discussed several ways to support filtering and search with indexes in PostgreSQL. Why are more needed, and why haven’t these types of index been covered yet? Prior discussion of this topic focused on the most common indexes, those that are needed in nearly any application. However, there are data types that cannot be efficiently supported with indexes such as B-trees. ...