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 (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.