On Sat, Oct 19, 2024 at 8:21 AM Dmitry Dolgov <9erthali...@gmail.com> wrote: > Currently it > supports only an increase of shared_buffers.
Just BTW in case it is interesting, Palak and I experimented with how to shrink the buffer pool while PostgreSQL is running, while we were talking about 13453ee (which it shares infrastructure with). This version fails if something is pinned and in the way of the shrink operation, but you could imagine other policies (wait, cancel it, ...): https://github.com/macdice/postgres/commit/db26fe0c98476cdbbd1bcf553f3b7864cb142247
