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

Поиск
Список
Период
Сортировка
От Jim Hurne
Тема Re: Sv: autovacuum failing on pg_largeobject and disk usage of thepg_largeobject growing unchecked
Дата
Msg-id OF3DF1DF08.87AFFCF7-ON8525858A.0050A459-8525858A.0050D38F@notes.na.collabserv.com
обсуждение исходный текст
Ответ на Sv: autovacuum failing on pg_largeobject and disk usage of thepg_largeobject growing unchecked  (Andreas Joseph Krogh <andreas@visena.com>)
Список pgsql-general
> In my experience vacuumlo,
https://www.postgresql.org/docs/12/vacuumlo.html,  is needed to remove
large objects, before vacuum can remove them from pg_largeobject.

Thanks for the suggestion! vacuumlo deletes any orphaned large objects,
presumably by using lo_unlink. While we don't use vacuumlo, our service
does clean up orphaned large objects in a similar way. And indeed,
inspecting the database reveals that there are no orphaned large objects.

Regards,

Jim Hurne




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

Предыдущее
От: Toomas Kristin
Дата:
Сообщение: Re: Conflict with recovery on PG version 11.6
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Importing a Large .ndjson file