Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL reclaiming table space - Mailing list pgsql-general

From Jasen Betts
Subject Re: PostgreSQL reclaiming table space
Date
Msg-id jpvnek$e1h$1@reversiblemaps.ath.cx
Whole thread Raw
In response to PostgreSQL reclaiming table space  (Anthony Bull <antsbull@gmail.com>)
List pgsql-general
Tree view 
On 2012-05-28, Anthony Bull <antsbull@gmail.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

pgsql-general by date:

Previous
From: Anthony Bull
Date:
Subject: Re: PostgreSQL reclaiming table space
Next
From: Stevo Slavić
Date:
Subject: Deleting, indexes and transactions