Re: Reindex doesn't eliminate bloat

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: Reindex doesn't eliminate bloat
Дата
Msg-id ce1c132d-bda2-9d5d-3f3a-635801ffc683@cox.net
обсуждение исходный текст
Ответ на Reindex doesn't eliminate bloat  (Ron Johnson <ron.l.johnson@cox.net>)
Ответы Re: Reindex doesn't eliminate bloat
Список pgsql-general
On 03/12/2018 10:48 PM, Nikolay Samokhvalov wrote:
On Tue, Mar 13, 2018 at 1:28 AM, Ron Johnson <ron.l.johnson@cox.net> wrote:
On 03/12/2018 05:20 PM, Nikolay Samokhvalov wrote:
On Tue, Mar 13, 2018 at 1:05 AM, Ron Johnson <ron.l.johnson@cox.net> wrote:
v8.4.12
 
This is *very* old version, not supported by the community for many years. Check https://www.postgresql.org/ to see currently supported versions.
You need to upgrade it.

Don't even think I'm in control of when -- or even if -- the customer decides to upgrade.

That being the case, do you have an answer to the question? 

Those queries from wiki for table and index bloat estimation are for estimation only. In many cases they show very wrong results. Better (yet not ideal) approach is using pgstattuple extension (though I'm not sure it existed back in 2009).

Can you provide table and index definition and, if you can, some sample data?

Sadly, no sample data.  (It's all PCI controlled.)

Index idx_item_mapping_rp7_y2016m03itemmapping_custom_userfield_801 has 40% bloat.

Thanks.

--
Angular momentum makes the world go 'round.
Вложения

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

Предыдущее
От: Nikolay Samokhvalov
Дата:
Сообщение: Re: Reindex doesn't eliminate bloat
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Programmatically duplicating a schema