Ibrar Ahmed - Percona - High-Performance PostgreSQL - Percona Live 2021

#PostgreSQL is one of the leading #OpenSource #databases. Out of the box, the default PostgreSQL configuration is not tuned for any particular workload. The default configuration is designed in such a way that PostgreSQL can run on any system using minimum resources. Consequently, a default installation of PostgreSQL does not give optimum performance on the high-performance machine because it is set up to use all available resources. Comment 💬, Share 🔗, Like 👍, and Subscribe ✅ to our channel 📺, and turn on the 🔔 to be alerted to new videos about #OpenSource #Databases... and many other things! https://percona.tv/subscribe PostgreSQL provides mechanisms that allow you to tune your database according to your workload and machine specification. Outside of PostgreSQL, though, we can tune the Linux kernel to allow the database load to work optimally. In this talk, we will learn how to tune some of PostgreSQL’s parameters, and we will see the effect of that tuning, but we will focus on demonstrating how to tune Linux for better Postgres performance. As there are so many Linux kernel parameters that can be tuned to improve the performance of PostgreSQL, I will also share the results of benchmarks obtained when tuning some of the Linux parameters. You can find more information about #PostgreSQL #Databases and Percona Database Events in these links 👇👇👇 Watch Percona Live 2021 Talks ⏩ https://percona.tv/PerconaLive2021 Postgresql Support ⏩ https://per.co.na/postgresql-support Postgresql info ⏩ https://per.co.na/postgresql-info Postgresql events ⏩ https://per.co.na/pl2020 Percona Distribution for PostgreSQL ⏩ https://per.co.na/postgresql Monitor your PostgreSQL For Free ⏩ https://percona.tv/pmm-yt Connect With us on our Social Networks 👇👇👇 Follow Percona on Twitter: https://per.co.na/twitter Follow Percona on Facebook: https://per.co.na/facebook Follow Percona on Instagram: https://per.co.na/instagram Follow Percona on LinkedIn: https://per.co.na/linkedin