Like this article? We recommend
Conclusion
You can see that a lot of performance can be gained by setting PostgreSQL's runtime parameter correctly. Although the default settings execute most queries really quickly, it is still worth performing some basic tuning. Especially complex queries may be accelerated significantly.
There are no general rules for tuning, and so many things have to be done using trial and error, but I guess most people will like this kind of work.
< Back
Page 3 of 3