Re: Vacuum full hang

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(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
>
>
>
> ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and
> unsubscribe commands go to majordomo(at)postgresql(dot)org

-----------------------------------------
Get your free web based email at trade-india.com.
"India's Leading B2B eMarketplace.!"
http://www.trade-india.com/