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.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
