Re: Autovacuum in the backend

Matthew T. O'Connor wrote:
> I don't think the current implementation if VACUUM can support that.  I 
> believe that all the work will get rolled back if gets canceled. 
> 
> Perhaps a decent solution would be to have autovacuum increase the 
> vacuum delay settings dynamically based on system load average.  That 
> way if a vacuum starts and the system starts to get busy, the autoavcuum 
> daemon can increase the vacuum delay settings and VACUUM would honor 
> this while running. 

I would like to have the GUC variables be honored while the system is
running, and that would all administrators to make changes from scripts.

--  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,
Pennsylvania19073