Vacuum seems to be halting on very large table - Mailing list pgsql-general

From K.T.
Subject Vacuum seems to be halting on very large table
Date
Msg-id 000801be655c$8de75fe0$2ddaa5ce@p2-400-death
Whole thread Raw
Responses shared tables
List pgsql-general
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



pgsql-general by date:

Previous
From: "K.T."
Date:
Subject: Re: [GENERAL] what on earth does this mean?!?
Next
From: Remigiusz Sokolowski
Date:
Subject: shared tables