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. <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> 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 > >
