16/11/2024 –, A001
Postgres has a very very very basic systemd support, and 0 support or integration of linux cgroups.
That’s where we are, in a systemd and K8S world, where containers are just here, always.
Using PostgreSQL-cgroups development branch, we will explore the cgroup (v2) API of choice for PostgreSQL: how to organize groups while providing support in usual package manager installation as well as in a docker like setup.
[only if time allows: Combined with linux PSI (Pressure Stalled Information), can we improve overall PostgreSQL performance ? Reduce the number of parameters to tune, giving more room to autotuning ? Can we get ride of the Out-Of-Memory blast ? Alternatively we may explore current systemd support in PostgreSQL and expected updates in this area]
We won’t focus on C code but on integration of cgroups [and PSI], their benefits and drawbacks in the PostgreSQL context.
