PostgreSQL container groups, aka cgroups down the road.

Speaker: Cédric Villemain

Type: 40min talk

Room: MDC room

Time: Nov 16 (Sat): 16:20

Duration: 0:40

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.