Re: feature: dynamic DB cache resizing

Ed L. wrote:
> We have ~75 pgsql clusters running in environments where downtime
> comes at a premium cost. We often run multiple clusters on a
> single box, and find it necessary to adjust the size of the
> static DB cache as we add or move clusters. Unfortunately, that
> means some downtime. It would be extremely useful in minimizing
> downtime to be able to dynamically resize the DB cache without
> having to restart the cluster. How hard would that be?

We can't think of how to do because it is all shared memory shared by
ever forked process --- does that help explain its complexity?
;-)

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073