effects of cancelling a vacuum full

From: "Anjan Dave" <adave(at)vantage(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: effects of cancelling a vacuum full
Date: 2006-01-18 18:17:53
Message-ID: 4BAFBB6B9CC46F41B2AD7D9F4BBAF78504015D89@vt-pe2550-001.vantage.vantage.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I just had to cancel one VACUUM FULL (of a 4.3m row table) that someone
ran in business hours. It was after an hour or so that I realized, and
it was blocking queries, running out of connections, so I cancelled it.
Are there any bad side effects of cancelling an ongoing full vacuum of a
table or a database? Does a partial full vacuum give back any space?

Thanks,
Anjan


This email message and any included attachments constitute confidential
and privileged information intended exclusively for the listed
addressee(s). If you are not the intended recipient, please notify
Vantage by immediately telephoning 215-579-8390, extension 1158. In
addition, please reply to this message confirming your receipt of the
same in error. A copy of your email reply can also be sent to
mailto:support(at)vantage(dot)com <blocked::mailto:support(at)vantage(dot)com> .
Please do not disclose, copy, distribute or take any action in reliance
on the contents of this information. Kindly destroy all copies of this
message and any attachments. Any other use of this email is prohibited.
Thank you for your cooperation. For more information about Vantage,
please visit our website at http://www.vantage.com.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2006-01-18 18:23:45 Re: effects of cancelling a vacuum full
Previous Message Jason Minion 2006-01-18 17:26:26 Re: Transferring DATA directory