On Fri, 23 Apr 2004 13:08:30 -0400 (EDT) Bruce Momjian <[EMAIL PROTECTED]> wrote: > D'Arcy J.M. Cain wrote: > > It seems to me that the point of pg_autovacuum would be to run 24/7 > > so that there is never big hit on the system. Perhaps it could be > > designed to throttle itself based on current system usage though. > > Or the number of connected backends, or both?
I am sure that there are lots of ways to guage. Not sure which is best but I am sure that the smart people here will figure it out. The important thing, I think, is to let the engine make the decision dynamically. Personally I don't have a "quiet time" per se but there are random quiet periods. Something that jumps into the fray at those points would be really nicwe. -- D'Arcy J.M. Cain <[EMAIL PROTECTED]|vex}.net> | Democracy is three wolves http://www.druid.net/darcy/ | and a sheep voting on +1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner. ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings