Re: Frequetly updated partial index leads to bloat on index for Postresql 11

Поиск
Список
Период
Сортировка
От Michael Lewis
Тема Re: Frequetly updated partial index leads to bloat on index for Postresql 11
Дата
Msg-id CAHOFxGqP_SgWhZ7ZAts8DMQTKdP_7=T0XJiF2XosZJJWii84+g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Frequetly updated partial index leads to bloat on index for Postresql 11  (Tom Dearman <tom.dearman@gmail.com>)
Список pgsql-general
Дерево обсуждения
Have you tried setting autovacuum to run quite aggressively, perhaps just on this table? Have you tried an index on the status column only, rather than partial?

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