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