From: | "K(dot)T(dot)" <kanet(at)calmarconsulting(dot)com> |
---|---|
To: | <pgsql-general(at)postgreSQL(dot)org> |
Subject: | Addendum: Vacuum seems to be halting on very large table |
Date: | 1999-03-03 10:42:08 |
Message-ID: | 000e01be6562$7da4b820$2ddaa5ce@p2-400-death |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)calmarconsulting(dot)com>
To: pgsql-general(at)postgreSQL(dot)org <pgsql-general(at)postgreSQL(dot)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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Karl Auer | 1999-03-03 10:58:04 | Re: [GENERAL] what on earth does this mean?!? |
Previous Message | K.T. | 1999-03-03 10:18:46 | Re: [GENERAL] selects on datetime |