Re: PostgreSQL reclaiming table space

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: PostgreSQL reclaiming table space
Date: 2012-05-28 11:27:16
Message-ID: jpvnek$e1h$1@reversiblemaps.ath.cx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2012-05-28, Anthony Bull <antsbull(at)gmail(dot)com> wrote:

> After that, I ran a VACUUM FULL across the entire database, and it returned
> about 1GB to the operating system, which I think was from another large
> table that got cleaned out (but not recreated).

try a REINDEX

--
⚂⚃ 100% natural

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Anthony Bull 2012-05-28 11:28:14 Re: PostgreSQL reclaiming table space
Previous Message Anthony Bull 2012-05-28 11:23:10 Re: PostgreSQL reclaiming table space