Cédric Villemain

Fediverse Profile link: https://mastodon.tetaneutral.net/@c2main

Other Social: https://git.data-bene.io/cedric

github profile: https://github.com/c2main

gitlab profile: https://gitlab.com/c2main

Debian user for nearly 25 years, and working on PostgreSQL for nearly 20 years.

Founder of 2ndQuadrant France, now Data Bene, company dedicated to PostgreSQL.

I like "system" things but not only, and PostgreSQL has the right balance of good C code, system requirements and maths.

Accepted Talks:

PostgreSQL container groups, aka cgroups down the road.

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.