Vacuum Doesn't Recover Disk Space

From: "j a" <inboundfilter(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Vacuum Doesn't Recover Disk Space
Date: 2007-11-06 17:36:45
Message-ID: 9da20ce20711060936q16611447o9b00da179533846b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2007-11-06 17:42:02 Re: Vacuum Doesn't Recover Disk Space
Previous Message Dávið Klein Sundsskarð 2007-11-06 11:24:46 Log statements by username