Date: 2025-05-15
Time: 13:00–13:50
Room: Breakout Room 2
Level: Intermediate
The size of shared memory segment of PostgreSQL is generally dominated by buffer pages, but also contains a lot of other data structs.
Work is ongoing to scale the memory used by buffer pages dynamically, but other shared structures will be (much) less easy to scale dynamically. As many of these shared objects are allocated with full usage in mind, reducing the memory usage of these shared objects will increase the dynamic scalability of a running database system.
In this talk, I'll cover some large shared memory areas, and how we can improve Postgres' scalability by reducing their footprint.