Reclaiming space from a toast table

From: "Benjamin Krajmalnik" <kraj(at)illumen(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Reclaiming space from a toast table
Date: 2010-03-31 04:20:46
Message-ID: F4E6A2751A2823418A21D4A160B689886141E3@fletch.stackdump.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

We recently added a text field to a table, and ended up dropping it and
moving it to a separate related table for performance reasons.

Previously, the toast table size was negligible, but now it is over
250MB.

I have tried performing a vacuum full against the table (this is an
inherited table), but it did not appear to reclaim the space.

Is there any way to reclaim the space other than a dump/restore of the
tables?

Browse pgsql-admin by date

  From Date Subject
Next Message Gnanakumar 2010-03-31 06:41:26 Statistics Collector not collecting server activities
Previous Message Dai, Tino 2010-03-31 02:07:54 Re: Migrate postgres to newer hardware