© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2024
H. Dombrovskaya et al.PostgreSQL Query Optimizationhttps://doi.org/10.1007/979-8-8688-0069-6_15

15. More Complex Filtering and Search

Henrietta Dombrovskaya1  , Boris Novikov2 and Anna Bailliekova3
(1)
DRW Holdings, Chicago, IL, USA
(2)
Database expert, Helsinki, Finland
(3)
UrbanFootprint, Milwaukee, Wisconsin, USA
 

Previous chapters discussed several ways to support filtering and search with indexes in PostgreSQL. Why are more needed, and why haven’t these indexes 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 ...

Get PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.