Partial/interrupted VACUUM FULL?

Поиск
Список
Период
Сортировка
Искать

Partial/interrupted VACUUM FULL?

От:
Jeff Boes <jboes@nexcerpt.com>
Дата:
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?

От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
Jeff Boes  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
FAQ