Re: Changing shared_buffers without restart

Поиск
Список
Период
Сортировка
От Thomas Munro
Тема Re: Changing shared_buffers without restart
Дата
Msg-id CA+hUKGL5hW3i_pk5y_gcbF_C5kP-pWFjCuM8bAyCeHo3xUaH8g@mail.gmail.com
обсуждение исходный текст
Ответы Re: Changing shared_buffers without restart
Список pgsql-hackers
On Sat, Oct 19, 2024 at 8:21 AM Dmitry Dolgov <9erthalion6@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



В списке pgsql-hackers по дате отправления: