| From: | Thomas Munro <thomas(dot)munro(at)gmail(dot)com> |
|---|---|
| To: | Dmitry Dolgov <9erthalion6(at)gmail(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Changing shared_buffers without restart |
| Date: | 2024-11-07 01:05:52 |
| Message-ID: | CA+hUKGL5hW3i_pk5y_gcbF_C5kP-pWFjCuM8bAyCeHo3xUaH8g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Sat, Oct 19, 2024 at 8:21 AM Dmitry Dolgov <9erthalion6(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2024-11-07 01:06:37 | Re: Converting contrib SQL functions to new style |
| Previous Message | Paul Jungwirth | 2024-11-07 01:03:09 | Re: SQL:2011 application time |