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. > <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... >> >> >> 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 [EMAIL PROTECTED] ----------------------------------------- Get your free web based email at trade-india.com. "India's Leading B2B eMarketplace.!" http://www.trade-india.com/ ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
