Partial/interrupted VACUUM FULL?

From: Jeff Boes <jboes(at)nexcerpt(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Partial/interrupted VACUUM FULL?
Date: 2003-10-27 19:51:34
Message-ID: 59de30841bc9faf12c289599a23c62c6@news.teranews.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Siddharth Rath (sirath) 2003-10-27 20:12:03 Need your help
Previous Message pginfo 2003-10-27 17:21:40 another pg database corruption?