PostgreSQL container groups, aka cgroups down the road.

by Cédric Villemain

At: MiniDebConf Toulouse 2024
https://toulouse2024.mini.debconf.org...

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.

Room: MDC room
Scheduled start: 2024-11-16 17:20:00+01:00