Thanks for the tip. I probably should've waited for vacuum to actually
finish instead of cancelling it prematurely (thinking PG Admin was
On Nov 6, 2007 12:42 PM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:
> On 11/6/07, j a <inboundfilter(at)gmail(dot)com> wrote:
> > I have a large table that I remove around 10m rows from every 2 months. I
> > try running Vacuum Full w/Analyze (both boxes checked in PG Admin), but the
> > disk space is never returned to the system. Any way I can force this?
> > I'm running 7.4 on CentOS4.3
> You likely have index bloat. try reindexing.
In response to
pgsql-admin by date
|Next:||From: Tom Lane||Date: 2007-11-07 05:11:10|
|Subject: Re: alter table serial->int |
|Previous:||From: Erik Aronesty||Date: 2007-11-06 21:59:44|
|Subject: alter table serial->int|