Postgres Pro
Downloads
Home   >   mailing lists

Re: Vacuum Doesn't Recover Disk Space - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: Vacuum Doesn't Recover Disk Space
Date
Msg-id dcc563d10711060942t13850012p986b1d6db04e96e0@mail.gmail.com
Whole thread Raw
In response to Vacuum Doesn't Recover Disk Space  ("j a" <inboundfilter@gmail.com>)
Responses Re: Vacuum Doesn't Recover Disk Space  ("j a" <inboundfilter@gmail.com>)
List pgsql-admin
Tree view 
On 11/6/07, j a <inboundfilter@gmail.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.

pgsql-admin by date:

Previous
From: "j a"
Date:
Subject: Vacuum Doesn't Recover Disk Space
Next
From: Devrim GÜNDÜZ
Date:
Subject: Re: Source of pgpool2 manual