Re: Accounting for between table correlation

Поиск
Список
Период
Сортировка
От Michael Lewis
Тема Re: Accounting for between table correlation
Дата
Msg-id CAHOFxGq4zH4CYX4BOMH3O5a0=J3oWyJbYJU6USxwOgHubok-VA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Accounting for between table correlation  (Thomas Kellerer <shammat@gmx.net>)
Список pgsql-general
Дерево обсуждения
On Fri, Jan 15, 2021 at 9:10 AM Thomas Kellerer <shammat@gmx.net> wrote:
Maybe there are many "idle in transaction" sessions that prevent autovacuum from properly
analyzing those tables. Or maybe for some unknown reason autovacuum was turned off.
Or maybe they receive a lot of bulk loads which would require a manual
analyze.

"hundreds of millions of rows"

Also of note that the default autovacuum settings for scale factor of 10-20% for vacuum & analyze behavior may need to be lowered for such a table. OP has chimed in that they believe it is being vacuumed/analyzed often enough, but if data is primarily or onnly maintained by bulk load, it would seem like autovacuum/analyze wouldn't be a factor anyway.

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

Предыдущее
От: Michael Lewis
Дата:
Сообщение: Re: Accounting for between table correlation
Следующее
От: Michael Lewis
Дата:
Сообщение: Re: time-based range partitioning and truncate/delete different timezones