<[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]
