Re: Vacuum full hang

<mallah@trade-india.com> wrote in message
news:8162.203.122.61.30.1044192306.squirrel@mail.trade-india.com...
>
>
> 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