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: Vacuum seems to be halting on very large table
Date: 1999-03-03 09:59:38
Message-ID: 000801be655c$8de75fe0$2ddaa5ce@p2-400-death
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Remigiusz Sokolowski 1999-03-03 10:00:28 shared tables
Previous Message K.T. 1999-03-03 09:55:48 Re: [GENERAL] what on earth does this mean?!?