Reclaiming space from a toast table

Поиск
Список
Период
Сортировка
От Benjamin Krajmalnik
Тема Reclaiming space from a toast table
Дата
Msg-id F4E6A2751A2823418A21D4A160B689886141E3@fletch.stackdump.local
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: "Dai, Tino"
Дата:
Сообщение: Re: Migrate postgres to newer hardware
Следующее
От: "Gnanakumar"
Дата:
Сообщение: Statistics Collector not collecting server activities