Re: partial VACUUM FULL

Joseph Shraibman wrote:
> If I cancel a VACUUM FULL, is the work that was done up until that point
> thrown away?  I have a table that needs vacuuming but I can't accept the
> downtime involved in vacuuming.

Not sure about the "cancel vacuum full" question, but I had some other thoughts
for you.

Keep in mind that a plain vacuum can do a lot of good if done regularly, and
it doesn't lock tables, thus the database can be in regular use while it's
run.  As a result, there is no downtime involved with regularly scheduled
vacuums.

There _can_ be a performance hit while vacuum is running, so you may need to
take that into account.  But I would expect that the performance hit incurred
during running vacuum will be less than that of not running it for long
periods of time.

--
Bill Moran
Potential Technologies
http://www.potentialtech.com