PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries

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

16. Ultimate Optimization Algorithm

Henrietta Dombrovskaya¹  , Boris Novikov² and Anna Bailliekova³

(1)

DRW Holdings, Chicago, IL, USA

(2)

Database expert, Helsinki, Finland

(3)

UrbanFootprint, Milwaukee, Wisconsin, USA

 

The preceding chapters covered a lot of optimization techniques: not only different ways to optimize SQL statements but also how database design affects performance, the importance of working together with application developers, the use of functions, and many other aspects of database performance.

Still, the question posed in the Introduction remains: ...