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@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
