are u sure VACUUM FULL is hanging?
run in verbose mode...
VACUUM FULL VERBOSE ANALYZE <tablename>
and you are really desperate get the pid of the
backend who is doing the vacuum and
strace -p <pid> i am sure u will see it spitting lots of read and writes.
;-)
regds
mallah.
> <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
>
>
>
> ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and
> unsubscribe commands go to majordomo@postgresql.org
-----------------------------------------
Get your free web based email at trade-india.com.
"India's Leading B2B eMarketplace.!"
http://www.trade-india.com/
