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. > I'm trying to vacuum full a table ( Postgres 7.2.3 ) > but the command: > vacuum full <my_table> > hang and all processes that are trying to update that table hang too, the CPU >occupation for > the process that perform the > vacuum is 0. What is going on? > > > > Ciao > Gaetano > > > > ---------------------------(end of broadcast)--------------------------- TIP 5: Have >you > checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html ----------------------------------------- Get your free web based email at trade-india.com. "India's Leading B2B eMarketplace.!" http://www.trade-india.com/ ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
