Reindex doesn't eliminate bloat

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Reindex doesn't eliminate bloat
Дата
Msg-id 8ba3c6c1-709b-d853-97f0-9ef458528b3d@cox.net
обсуждение исходный текст
Ответы Re: Reindex doesn't eliminate bloat
Re: Reindex doesn't eliminate bloat
Список pgsql-general
v8.4.12

According to this (https://pastebin.com/TJB32n5M) query, which I thought I 
got from https://wiki.postgresql.org/wiki/Index_Maintenance, a list of 
indexes and their bloat is generated.

After reindexing a table with a large amount of reported bloat (column 
bloat_pct says 29%), re-running the query shows no change in the amount of 
bloat.  This is a historical table, and VACUUM VERBOSE shows that there's 
nothing to free up.

Is this something that I must live with, or am I misinterpreting the query?

Thanks,

-- 
Angular momentum makes the world go 'round.


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

Предыдущее
От: Andreas Joseph Krogh
Дата:
Сообщение: Logical decoding on standby
Следующее
От: Nikolay Samokhvalov
Дата:
Сообщение: Re: Reindex doesn't eliminate bloat