Re: autovacuum failing on pg_largeobject and disk usage of thepg_largeobject growing unchecked

Поиск
Список
Период
Сортировка
От Michael Lewis
Тема Re: autovacuum failing on pg_largeobject and disk usage of thepg_largeobject growing unchecked
Дата
Msg-id CAHOFxGoOaVk6KPQgrijZAfrbAdkwW3jQZTjb=swOXU4dk8MidQ@mail.gmail.com
обсуждение исходный текст
Ответ на RE: autovacuum failing on pg_largeobject and disk usage of thepg_largeobject growing unchecked  ("Jim Hurne" <jhurne@us.ibm.com>)
Ответы Re: autovacuum failing on pg_largeobject and disk usage of thepg_largeobject growing unchecked  ("Jim Hurne" <jhurne@us.ibm.com>)
Список pgsql-general
Дерево обсуждения
On Tue, Jun 23, 2020 at 2:34 PM Jim Hurne <jhurne@us.ibm.com> wrote:
Sure! Below are more of the details from the same set of logs. Looking at
them myself, I see that there is always some percentage of tuples that are
dead but are not yet removable. And that number increases on every vacuum,
which might explain in part why autovacuum elapsed times keep increasing.

What causes a dead tuple to be unremovable?

Here are a couple good write ups.

Long running transactions are the common one that I see. You might be dealing with replication slots or prepared transactions. Basically, if some process might see that "old truth", then it can't be vacuumed away yet.

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

Предыдущее
От: "Jim Hurne"
Дата:
Сообщение: RE: autovacuum failing on pg_largeobject and disk usage of thepg_largeobject growing unchecked
Следующее
От: Michael Lewis
Дата:
Сообщение: Re: Persistent Connections