Mostly mistaken and ignored parameters while optimizing a #PostgreSQL #database - #Percona Live 2020

Comment 💬, Share 🔗, Like 👍🏻, and Subscribe ✅ to our channel

Avi Vallarapu talked about Optimizing a #PostgreSQL #database may be a challenge if some of the important parameters are ignored. And a bigger challenge may be the algorithm behind setting those parameters correctly. In my experience with #PostgreSQL Consulting for more than a decade, I have seen a bigger list of parameters that are wrongly set or ignored. This talk details such a list of important #PostgreSQL parameters considering the latest releases with some good description, that could drastically improve the performance graph when properly set. We shall also discuss some mathematical formulae and some extensions helpful to expose the diagnostic data for tuning these parameters.* This talk should help both the beginners and also #PostgreSQL admins to go back and check if they have tuned these parameters correctly in their #PostgreSQL environments.

📺Subscribe To Our Channel and Get More information about #OpenSource #Databases, #kubernetes and many other things.

You can find more about #PostgreSQL Support and Percona Live Online 2020 in these links 👇🏻👇🏻👇🏻

Connect With us on our Social Networks 👇🏻👇🏻👇🏻

[marcinpohl]

Is there a link to the slides somewhere?

[vitache]

Thanks for this video. I have learnt a lot. I have one question. I upgraded from postgresql 9.6 to 10.10. The server was slow and after doing some tuning on the server nothing worked. But when we down graded back to postgresql 9.6, performance improved. What could be the root of poor performance when the server was upgraded to 10.10?