Re: Vacuum full hang

<mallah(at)trade-india(dot)com> wrote in message
news:8162(dot)203(dot)122(dot)61(dot)30(dot)1044192306(dot)squirrel(at)mail(dot)trade-india(dot)com(dot)(dot)(dot)
>
>
> Hmm. VACUUM FULL is supposed to do that only i guess.
>
> since version 7.2 ordinary VACUUM does not locks the table.
> and VACUUM can be performed on a live system.
>
> VACUUM FULL does the disk space reclaimation and is supposed to lock
> table to prevent updates.
>
> i guess you can do a VACUUM ANALYZE on the table instead.
>
> regds
> Mallah.

Your guess is wrong, in my case the vacuum analyze is not enough, I have a
lot
of space wasted in my HD, I need a vacuum analyze and I don't care if some
process
during the vacuum hang ( just during the vacuum operation ) but here the
strange is
that also the "vacuum" hang.

Ciao
Gaetano