RE: autovacuum failing on pg_largeobject and disk usage of the pg_largeobject growing unchecked

Поиск
Список
Период
Сортировка
От Jim Hurne
Тема RE: autovacuum failing on pg_largeobject and disk usage of the pg_largeobject growing unchecked
Дата
Msg-id OF83861189.C9BB76A1-ON85258591.004BA3E3-85258591.004BD464@notes.na.collabserv.com
обсуждение исходный текст
Ответ на RE: autovacuum failing on pg_largeobject and disk usage of the pg_largeobject growing unchecked  ("Daniel Verite" <daniel@manitou-mail.org>)
Ответы RE: autovacuum failing on pg_largeobject and disk usage of the pg_largeobject growing unchecked  ("Daniel Verite" <daniel@manitou-mail.org>)
Список pgsql-general
"Daniel Verite" <daniel@manitou-mail.org> wrote on 06/22/2020 06:00:37 PM:
> If you can arrange a maintenance window, a faster way to rebuild
> pg_largeobject when it contains mostly empty pages can be to:

Thanks Daniel. If we cannot arrange for a maintenance window, is this the
sort of thing that pg_repack[1] could be used to do?

Would pg_repack require setting allow_system_table_mods to on?

[1] https://github.com/reorg/pg_repack

Regards,

Jim Hurne




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

Предыдущее
От: Jaime Soler
Дата:
Сообщение: Re: pgbench and timestamps
Следующее
От: "Daniel Verite"
Дата:
Сообщение: RE: autovacuum failing on pg_largeobject and disk usage of the pg_largeobject growing unchecked