Re: vacuum full

Поиск
Список
Период
Сортировка
От Vijaykumar Jain
Тема Re: vacuum full
Дата
Msg-id CAM+6J96p6o0ruRwn32CGqj7P778vpwAxOW-R=UToYy3TzPX7Rg@mail.gmail.com
обсуждение исходный текст
Ответ на vacuum full  (Vijaykumar Jain <vijaykumarjain.github@gmail.com>)
Ответы RE: vacuum full  (Ian Dauncey <Ian.Dauncey@bankzero.co.za>)
Список pgsql-general
Дерево обсуждения
On Mon, 30 Aug 2021 at 23:12, Vijaykumar Jain <vijaykumarjain.github@gmail.com> wrote:
Just keeping it in a separate email, incase this is thrashed down.
vacuum full has a lot of problem stories, not just because the db gets locked, but also because it is mostly (mis)used when there are space issues.

 
ok ignore. 
I think querying the disk for available space may be shell access from the client, a security issue.
Also, a 10GB table with all dead tuples is 100% bloat, and would not really need additional space for table rebuilds.
I think we can just put out some queries like bloat estimation  of relations, to get an idea of wasted space and used space
and estimate based on that on how much would be taken up from the disk before being cleaned up.



 
--
Thanks,
Vijay
Mumbai, India

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Idempotent DDL Updates
Следующее
От: Julien Rouhaud
Дата:
Сообщение: Re: Idempotent DDL Updates