© Henrietta Dombrovskaya, Boris Novikov, Anna Bailliekova 2021
H. Dombrovskaya et al.PostgreSQL Query Optimizationhttps://doi.org/10.1007/978-1-4842-6885-8_7

7. Long Queries: Additional Techniques

Henrietta Dombrovskaya1  , Boris Novikov2 and Anna Bailliekova3
(1)
Braviant Holdings, Chicago, IL, USA
(2)
HSE University, Saint Petersburg, Russia
(3)
Zendesk, Madison, WI, USA
 

Chapter 6 discussed multiple ways of improving the performance of long queries. Thus far, all covered techniques relate to rewriting queries without creating any additional database objects. This chapter addresses additional ways of improving long query performance, including different ways to materialize intermediate results. Temporary tables, CTEs (common table expressions), views, ...

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

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.