From: | "K(dot)T(dot)" <kanet(at)calmarconsulting(dot)com> |
---|---|
To: | "Tim Stoddard" <tims(at)dcs(dot)state(dot)ar(dot)us>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: [GENERAL] Vacuum |
Date: | 1999-03-22 08:59:08 |
Message-ID: | 004a01be7442$401f28c0$43d8a5ce@p2-400-death |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)dcs(dot)state(dot)ar(dot)us>
To: pgsql-general(at)postgresql(dot)org(dot)pgsql-sql@postgreSQL.org
<pgsql-general(at)postgresql(dot)org(dot)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
>======================================================================
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Richi Plana | 1999-03-22 12:30:26 | max # concurrent? |
Previous Message | K.T. | 1999-03-22 08:51:00 | Re: [GENERAL] Creating Users |