Cédric Villemain has submitted a new session!

Resource Control Admission - I have a date with my PSI

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.

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 auto-vacuum when it's possible.


Open session

These notifications can be turned off on Edit event page.