PostgreSQL High-Performance Tuning and Optimization
source link: https://www.percona.com/resources/webinars/postgresql-high-performance-tuning-and-optimization-2020
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
PostgreSQL is one of the leading open-source databases. Out of the box, the default PostgreSQL configuration is not tuned for any workload. Thus, any system with the least resources can run it. PostgreSQL does not give optimum performance on high permanence machines because it is not using all available resources. PostgreSQL provides a system where you can tune your database according to your workload and machine specifications. In addition to PostgreSQL, we can also tune our Linux box so that the database load can work optimally.
In this webinar on PostgreSQL High-Performance Tuning and Optimization, we will learn how to tune PostgreSQL and we’ll see the results of that tuning. We will also touch on tuning some Linux kernel parameters.
About the Author
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK