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/