I have a date with my PSI

Speaker

About this talk

Video of a conference talk about Pressure Stall Information (PSI) in PostgreSQL. PSI has been present in Linux for numerous years, but even so, it's not well known in the world of PostgreSQL. In this talk, we'll introduce PSI along with what it brings, how it works, and where it is used today (spoiler: Facebook did a lot in this area!). Then, we will use the pg_psi extension to start "playing" with PSI and react to system events. To do this, we will define system triggers so we're notified when the server is slowing down. This gives us the chance to adjust the workload before it's too late or give more resources to background tasks like autovacuum when it's possible. Cédric Villemain embarked on his PostgreSQL journey in 2004, exploring its myriad facets ever since. Cédric is the founder of Data Bene, previously 2ndQuadrant France, a global company dedicated to open source, PostgreSQL and its extensions. ► Video bookmarks: ⏩ 00:00 Introduction and agenda ⏩ 02:38 PostgreSQL processes categorized ⏩ 04:46 PostgreSQL resource requirements ⏩ 07:41 Pressure Stall Information (PSI) ⏩ 09:49 Observing pressure ⏩ 11:38 CPU avg vs loadavg ⏩ 13:26 PSI visualization (pseudo demo) ⏩ 15:56 Event notification ⏩ 17:28 Cgroup support ⏩ 19:00 Bringing PSI to PostgreSQL ⏩ 21:18 The future of PSI ⏩ 23:56 A “demo” ⏩ 25:31 Links & questions Resources: 💡 Pg_psi Project - http://codeberg.org/Data-Bene/pg_psi 💡 Custom out-of-memory killers in pbf - http://lwn.net/Articles/1019230/ 💡 Linux kernel doc about PSI - http://docs.kernel.org/accounting/psi.html 💡 Prometheus Exporter - https://github.com/cloudflare/psi_exporter 📕 Everything you need to know about POSETTE: An Event for Postgres 2025 can be found at: https://posetteconf.com ✅ Learn more: Watch more POSETTE talks: https://aka.ms/posette-playlist 📌 Let’s connect:   LinkedIn - https://www.linkedin.com/company/posetteconf/ X – @PosetteConf, http