Re: Table Bloat still there after the Vacuum

Поиск
Список
Период
Сортировка
От Cédric Villemain
Тема Re: Table Bloat still there after the Vacuum
Дата
Msg-id r2je94e14cd1004260838l789ec144oaa49b3ebe490e8a5@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Table Bloat still there after the Vacuum  (Cédric Villemain <cedric.villemain.debian@gmail.com>)
Список pgsql-general
2010/4/26 Cédric Villemain <cedric.villemain.debian@gmail.com>:
> 2010/4/26 akp geek <akpgeek@gmail.com>:
>> Hi All -
>>                   I have a table bloated with following details
>> rows:29431 pages:516039 shouldbe:534 (966.4X) wasted size:4223016960 (3 GB)
>> *
>
> I think this info come from check_postgres nagios script.
> As said in the doc, this info is not 100% sure : it depend on the last
> analyze *and* the type the columns *and* the distribution of data in
> those columns.
> I suggest you to check the pg_stats.avg_width relative to this table.
>
> And, vacuum verbose information is good for diagnostics...

and the verbose said there is actually a problem :-)

check long running transaction, idle in connection,  ... they prevent
the vacuum things


>
>>                   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
>
>
>
> --
> Cédric Villemain
>



--
Cédric Villemain

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

Предыдущее
От: akp geek
Дата:
Сообщение: Re: Table Bloat still there after the Vacuum
Следующее
От: Vincenzo Romano
Дата:
Сообщение: Re: Inheritance efficiency