Thread: Partial/interrupted VACUUM FULL?

Partial/interrupted VACUUM FULL?

From
Jeff Boes
Date:
We have a pretty large table with many deleted rows. A normal VACUUM of
this table now takes over an hour. I'd like to run a full VACUUM to
recover the mostly wasted space, but I know it will take several hours.
Can I do a VACUUM FULL for a while, and interrupt it (CTRL-C at the psql
prompt) without undoing its progress?

--
Jeff Boes                                      vox 269.226.9550 ext 24
Database Engineer                                     fax 269.349.9076
Nexcerpt, Inc.                                 http://www.nexcerpt.com
            ...Nexcerpt... Extend your Expertise


Re: Partial/interrupted VACUUM FULL?

From
Tom Lane
Date:
Jeff Boes <jboes@nexcerpt.com> writes:
> Can I do a VACUUM FULL for a while, and interrupt it (CTRL-C at the psql
> prompt) without undoing its progress?

No.  You can safely interrupt it, but you won't have accomplished
anything if you do.

            regards, tom lane