© 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_6

6. Long Queries and Full Scans

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

Chapter 5 discussed short queries and explained how to identify short queries and optimization strategies and techniques applicable to them. It also covered the importance of indexes for short queries, the most commonly used index types, and their applications. Chapter 5 also provided an opportunity to practice reading execution plans and, hopefully, acquire ...

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.