Skip navigation
Cédric Villemain

Cédric Villemain

Data Bene CEO

Cédric 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.

POSETTE 2025 Talk

Resource Control Admission - I have a date with my PSI

(Livestream 4)

Pressure Stall Information (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.

talk bubbles
Join the conversation

Use the hashtag #PosetteConf