Reclaiming space from a toast table - Mailing list pgsql-admin

From Benjamin Krajmalnik
Subject Reclaiming space from a toast table
Date
Msg-id F4E6A2751A2823418A21D4A160B689886141E3@fletch.stackdump.local
Whole thread Raw
List 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?

pgsql-admin by date:

Previous
From: "Dai, Tino"
Date:
Subject: Re: Migrate postgres to newer hardware
Next
From: "Gnanakumar"
Date:
Subject: Statistics Collector not collecting server activities