Postgres Pro
Downloads
Home   >   mailing lists

Partial/interrupted VACUUM FULL? - Mailing list pgsql-admin

From Jeff Boes
Subject Partial/interrupted VACUUM FULL?
Date
Msg-id 59de30841bc9faf12c289599a23c62c6@news.teranews.com
Whole thread Raw
Responses Re: Partial/interrupted VACUUM FULL?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Visibility of objects in other schema's
Next
From: "Siddharth Rath (sirath)"
Date:
Subject: Need your help