Thread: Vacuum seems to be halting on very large table

Vacuum cammand seems to hang (I waited 1-2 hours) on a table that is empty,
but is still using over 66 MB of disk space.  This is due to deletes because
this table is completely reloaded from text files.

The command I am using is "vacuum verbose analyze" from the psql prompt.
Anyone experience this problem?  Anyone got any ideas on how to debug it?
No msg exists in the server.log other than the "notice" for the table (the
statistics).

TIA

-Kane

Hi!
I'm wonder if I could produce shared tables like pg_database or pg_shadow
by myself.
I've found in pg_class a field called relisshared and suppose, that
setting its value to true could do the trick, but it seems that I need
more than only this. Anybody knows what is it?
    TIA
    Rem

-------------------------------------------------------------------*------------
Remigiusz Sokolowski      e-mail: rems@gdansk.sprint.pl           * *
-----------------------------------------------------------------*****----------