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_6

6. Long Queries and Full Scans

Henrietta Dombrovskaya¹  , Boris Novikov² and Anna Bailliekova³

(1)

Braviant Holdings, Chicago, IL, USA

(2)

HSE University, Saint Petersburg, Russia

(3)

Zendesk, Madison, WI, USA

 

Chapter 5 discussed short queries and explained how to identify short queries and what optimization strategies and techniques can be used with them. It also covered the importance of indexes for short queries and the most commonly used index types and their applications. Chapter 5 also gave the opportunity to practice execution plan reading skills and hopefully acquire some confidence in the ...