Changing shared_buffers on the fly
Presenters Ashutosh Bapat Source PGConf.dev 2025 Level Up Your PostgreSQL: A Deep Dive into Dynamic Shared Buffer Resizing 🚀 For PostgreSQL DBAs and developers, performance is everything. But what happens when your database is struggling under load? Often, that means adjusting the shared buffers – a critical component for caching data and speeding up queries. Unfortunately, the current process for resizing these buffers in PostgreSQL is… well, let’s just say it’s not ideal. 😬 ...