Reclaiming space from a toast table

Reclaiming space from a toast table

am 31.03.2010 06:20:46 von Benjamin Krajmalnik

This is a multi-part message in MIME format.

------_=_NextPart_001_01CAD089.890CC1DF
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

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?


------_=_NextPart_001_01CAD089.890CC1DF
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" =
xmlns=3D"http://www.w3.org/TR/REC-html40">


charset=3Dus-ascii">









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?









------_=_NextPart_001_01CAD089.890CC1DF--