I had same problem...tables that have heavy deletes/inserts start to eat up
tons of disk space and the vacuum seemed to hang. I posted too, but got no
replies...so my solution was to dump the table and delete the database and
recreate it all. Also I run the vaccum more often to avoid the prob in the
future...
-----Original Message-----
From: Tim Stoddard <tims@dcs.state.ar.us>
To: pgsql-general@postgresql.org.pgsql-sql@postgreSQL.org
<pgsql-general@postgresql.org.pgsql-sql@postgreSQL.org>
Date: Thursday, March 18, 1999 2:34 PM
Subject: [GENERAL] Vacuum
>When I delete 2k-3k of records from a table the vacuum process seems
>to take forever. I have let the vacuum run for 24 hours before with
>not luck.
>
>Can someone one explain to me what is going on?
>
>--
>Tim Stoddard
>======================================================================
>
> Open Systems UNIX
>
> In a world without fences, who needs Gates? -- Unknown
>======================================================================
>
>
>
>