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, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
