Cải thiện khả năng mở rộng; Giảm chi phí hoạt động trong bộ nhớ chia sẻ (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/pgconfdev2025/schedule/session/359-improving-scalability-reducing-overhead-in-shared-memory/

🎬 See more PGConf.dev 2025 videos at https://www.youtube.com/playlist?list=PLTw6f6dqzO1tCLr_OHjZ37kY2r35u2tCq

Connect with us:

LinkedIn: https://www.linkedin.com/company/pgconf-dev/post

X https://twitter.com/pgconfdev

Mastodon: https://mastodon.social/@pgconfdev

Bluesky: https://bsky.app/profile/pgconf.dev

Web: https://pgconf.dev

#postgresql #PGConfDev