Re: delete and pg_toast = shrink database?

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: delete and pg_toast = shrink database?
Дата
Msg-id CAKFQuwZdRgAMW__2Ge99FmoMZ9GxYW4diCbu=-0sHUC7Ey3xiw@mail.gmail.com
обсуждение исходный текст
Ответ на delete and pg_toast = shrink database?  (Edwin UY <edwin.uy@gmail.com>)
Список pgsql-admin
Дерево обсуждения
On Thu, Feb 27, 2025 at 2:19 PM Edwin UY <edwin.uy@gmail.com> wrote:
Hi,

DB is currently 500G. About 75% of this is pg_toast.
Had advised the application team to check for data purging as there are some very old data.
Is it correct to assume that doing so should shrink the database size?
I believe I have to run vacuum full/table at some stage to really shrink it?


Yes, most likely to reclaim the space to the OS you will need to use vacuum full or equivalent.

David J.

В списке pgsql-admin по дате отправления: