Table Bloat still there after the Vacuum

Поиск
Список
Период
Сортировка
От akp geek
Тема Table Bloat still there after the Vacuum
Дата
Msg-id j2l2024a9fb1004260743n6a9e13eds80448a0abc697e84@mail.gmail.com
обсуждение исходный текст
Ответы Re: Table Bloat still there after the Vacuum  (Bill Moran <wmoran@potentialtech.com>)
Re: Table Bloat still there after the Vacuum  (Cédric Villemain <cedric.villemain.debian@gmail.com>)
Re: Table Bloat still there after the Vacuum  (Chris.Ellis@shropshire.gov.uk)
Список pgsql-general
Дерево обсуждения
Hi All -

                  I have a table bloated with following details
rows:29431 pages:516039 shouldbe:534 (966.4X) wasted size:4223016960 (3 GB) * 

                  I did  a vacuum on the database and also I did vacuumdb full on the table. Still there is no change. Can you please suggest if there is any other operation that can be done to take care of the issue

Thanks for the help


Regards

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Inheritance efficiency
Следующее
От: Bill Moran
Дата:
Сообщение: Re: Table Bloat still there after the Vacuum