Thread: Re: [GENERAL] Vacuum

Re: [GENERAL] Vacuum

From
"K.T."
Date:
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
>======================================================================
>
>
>
>