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 OFB99C007D.CA15CC8E-ON85258591.004ECAD1-85258591.004F258D@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 thepg_largeobject growing unchecked
Список pgsql-general
"Daniel Verite" <daniel@manitou-mail.org> wrote on 06/24/2020 10:08:27 AM:
> Unfortunately it [pg_repack] can't work with pg_largeobject

That is unfortunate, and potentially leaves us in a difficult spot.

Is it possible to configure PosgreSQL to use a user table for large
objects instead of a system table?

We're finding it to be especially difficult to maintain the pg_largeobject
system table (tweak autovacuum settings, manually cleanup with something
like pg_repack, etc), particularly since our PosrgreSQL instances are
hosted and controlled by another team.

Regards,

Jim Hurne




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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: pgbench and timestamps
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pgbench and timestamps