Re: [GENERAL] Vacuum - Mailing list pgsql-general

From K.T.
Subject Re: [GENERAL] Vacuum
Date
Msg-id 004a01be7442$401f28c0$43d8a5ce@p2-400-death
Whole thread Raw
List pgsql-general
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
>======================================================================
>
>
>
>





pgsql-general by date:

Previous
From: "K.T."
Date:
Subject: Re: [GENERAL] Creating Users
Next
From: Richi Plana
Date:
Subject: max # concurrent?