Re: Changing shared_buffers without restart
От | Dmitry Dolgov |
---|---|
Тема | Re: Changing shared_buffers without restart |
Дата | |
Msg-id | pkjfmei3j6yqmdi76cwzsmn4z34zg5yanb7rfv2rq4aik6ija3@xq6nrkvpya76 обсуждение исходный текст |
Ответ на | Re: Changing shared_buffers without restart (Andres Freund <andres@anarazel.de>) |
Ответы |
Re: Changing shared_buffers without restart
Re: Changing shared_buffers without restart |
Список | pgsql-hackers |
> On Mon, Jul 14, 2025 at 09:42:46AM -0400, Andres Freund wrote: > What on earth would be the point of putting a buffer on the freelist but not > make it reachable by the clock sweep? To me that's just nonsensical. To clarify, we're not talking about this scenario as "that's how it would work after the resize". The point is that to expand shared buffers they need to be initialized, included into the whole buffer machinery (freelist, clock sweep, etc.) and NBuffers has to be updated. Those steps are separated in time, and I'm currently trying to understand what are the consequences of performing them in different order and whether there are possible concurrency issues under various scenarios. Does this make more sense, or still not?
В списке pgsql-hackers по дате отправления: