Autovacuum potential bug

Поиск
Список
Период
Сортировка
От maschka, sam
Тема Autovacuum potential bug
Дата
Msg-id CACydT65+Z_B80xnc+byYxrm0gzGW+Ko+HMxBDb+5ks0C1ctiAQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Autovacuum potential bug  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Список pgsql-bugs
We have been seeing an issue where reads on a table seem to slowly degrade over time. When we run VACUUM ANALYZE on the table the operations perform much better. It usually takes about a week or two for the reads to degrade to a point where we have to manually run VACUUM ANALYZE. This has been happening to a handful of our tables. The mutation operations ran against these tables are mainly update operations. Very few insert and delete operations are ran against these tables. Also a jsonb object stores most of the data within each record. The size of the jsonb object can vary widely between records. We thought the autovacuum facility would have prevented us from having to periodically run VACUUM ANALYZE. Is this a bug or is it a configuration issue on our tables? 

Sam Maschka

Software Engineer
651-245-4054

nextworld

7979 E. Tufts Ave. Suite 900
Denver, CO 80237

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

Предыдущее
От: Tomas Vondra
Дата:
Сообщение: Re: BUG #16203: So difficult to set an use postgres
Следующее
От: Tomas Vondra
Дата:
Сообщение: Re: Autovacuum potential bug