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
Дата	16 июня 2020 г. 21:19:36
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 по дате отправления:

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

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