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

Поиск
Список
Период
Сортировка
От Andreas Joseph Krogh
Тема Sv: autovacuum failing on pg_largeobject and disk usage of thepg_largeobject growing unchecked
Дата
Msg-id VisenaEmail.74.9d4616d0a8a39a38.172befd99f2@tc7-visena
обсуждение исходный текст
Ответ на autovacuum failing on pg_largeobject and disk usage of the pg_largeobjectgrowing unchecked  ("Jim Hurne" <jhurne@us.ibm.com>)
Ответы Re: Sv: autovacuum failing on pg_largeobject and disk usage of thepg_largeobject growing unchecked
Список pgsql-general
Дерево обсуждения
På tirsdag 16. juni 2020 kl. 17:59:37, skrev Jim Hurne <jhurne@us.ibm.com>:
We have a cloud service that uses PostgreSQL to temporarily store binary
content. We're using PostgreSQL's Large Objects to store the binary
content. Each large object lives anywhere from a few hundred milliseconds
to 5-10 minutes, after which it is deleted.
[...]
 
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.
 
--
Andreas Joseph Krogh

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

Чтобы сделать работу с сайтом удобнее, мы используем cookie и аналитический сервис «Яндекс.Метрика». Продолжая пользоваться сайтом, вы соглашаетесь с их использованием.