Know bloat percentage after auto vacuum

Поиск
Список
Период
Сортировка
От satish v
Тема Know bloat percentage after auto vacuum
Дата
Msg-id CAPG-CvVyZEY6tjsEKJXZBW69pmWpaMrbf7TbnM3yQqBCU3tUow@mail.gmail.com
обсуждение исходный текст
Ответы Re: Know bloat percentage after auto vacuum  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список pgsql-admin
Hi all.

We have the table with 2 months data (approx 450GB). We deleted 17 days of data and auto vacuum performed on the table.new insertions are utilizing  that space,we want to perform the vacuum full and reclaim the space at os level but don't know how much free (unused) space available.how can we get the details.

Thanks in advance.

Regards,
Satish.

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

Предыдущее
От: Tyler Brock
Дата:
Сообщение: Re: Segfault during queries
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: Know bloat percentage after auto vacuum