Addendum: Vacuum seems to be halting on very large table

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
>
>

Browse pgsql-general by date

  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