Before anyone asks...I tried shutting down Postgres and restarting it to
disconnect any connections and I made all of my CGI scripts (the only users)
"000" so the database could not be accessed.
-----Original Message-----
From: K.T. <kanet@calmarconsulting.com>
To: pgsql-general@postgreSQL.org <pgsql-general@postgreSQL.org>
Date: Wednesday, March 03, 1999 4:59 AM
Subject: 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
>
>