Reclaiming space from a toast table
am 31.03.2010 06:20:46 von Benjamin KrajmalnikThis 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: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--