Date: 2025-05-14
Time: 16:30–16:55
Room: Breakout Room 3
Level: Advanced
Postgres has only incredibly basic systemd support, and no support or integration for Linux cgroups whatsoever.
Yet here we are, in a systemd and K8S world, where containers are ever-present.
Using the PostgreSQL-cgroups development branch, we will explore the cgroup (v2) API of choice for PostgreSQL and discuss how to organise groups while providing support in typical package manager installations, as well as in a Docker like setup.
Combined with Linux PSI (Pressure Stalled Information), can we improve overall PostgreSQL performance ? Reduce the number of parameters to manually tune, and give more control to autotuning ? Can we get rid of the Out-Of-Memory blast ?
We won't focus on C code but rather on the integration of cgroups and PSI, along with their benefits and drawbacks in the context of PostgreSQL.