Stephen wrote:
> I think adding tunable delay per-page loop into VACUUM will help keep system
> responsive at all times. In many cases, especially for mostly read-only
> tables, plain VACUUM does not need to complete immediately (VACUUM FULL
> should complete immediately). I prefer that VACUUM takes its sweet time to
> run as long as it doesn't disrupt other queries. See my other post on
> "VACUUM degrades performance significantly. Database becomes unusable!" on
> pgsql-general mailing list.
Of course, this makes VACUUM run longer, and if you are waiting for it
to finish, it would be worse, like if you are running it at night or
something.
I think the delay has to take into account the number of active
transactions or something.
-- 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