Improving scalability; Reducing overhead in shared memory (PGConf.dev 2025) скачать в хорошем качестве

Improving scalability; Reducing overhead in shared memory (PGConf.dev 2025)

Presented by Matthias van de Meent at PGConf.dev 2025 (https://2025.pgconf.dev) 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. https://www.pgevents.ca/events/pgconf... 🎬 See more PGConf.dev 2025 videos at    • PGConf.dev 2025   Connect with us: LinkedIn:   / post   X   / pgconfdev   Mastodon: https://mastodon.social/@pgconfdev Bluesky: https://bsky.app/profile/pgconf.dev Web: https://pgconf.dev #postgresql #PGConfDev