Re: Vacuum Doesn't Recover Disk Space

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "j a" <inboundfilter(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Vacuum Doesn't Recover Disk Space
Date: 2007-11-06 17:42:02
Message-ID: dcc563d10711060942t13850012p986b1d6db04e96e0@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Devrim GÜNDÜZ 2007-11-06 19:40:01 Re: Source of pgpool2 manual
Previous Message j a 2007-11-06 17:36:45 Vacuum Doesn't Recover Disk Space