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_10

10. What About Configuration Parameters?

Henrietta Dombrovskaya¹  , Boris Novikov² and Anna Bailliekova³

(1)

DRW Holdings, Chicago, IL, USA

(2)

Database expert, Helsinki, Finland

(3)

UrbanFootprint, Milwaukee, Wisconsin, USA

 

The Introduction to this book mentioned that most of the time, when people talk about “database tuning,” they assume that all performance problems can be fixed by figuring out optimal PostgreSQL configuration parameters.

Although some parameter tuning can indeed improve database performance, we are usually talking about 10%, 20%, and, in rare cases, ...