Re: effects of cancelling a vacuum full

From: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
To: Anjan Dave <adave(at)vantage(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: effects of cancelling a vacuum full
Date: 2006-01-18 18:23:45
Message-ID: 1137608625.25500.83.camel@state.g2switchworks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Wed, 2006-01-18 at 12:17, Anjan Dave wrote:
> 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?
>

No damage done.
No space returned.
Just wait and run it again later.
Tell your used to do a vacuum regular during business hours or you'll
have to give him a stern talking to.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message mcelroy, tim 2006-01-18 18:27:09 krb5_encrypt error
Previous Message Anjan Dave 2006-01-18 18:17:53 effects of cancelling a vacuum full