Postgres Pro
Downloads
Home   >   mailing lists

Sv: autovacuum failing on pg_largeobject and disk usage of thepg_largeobject growing unchecked - Mailing list pgsql-general

From Andreas Joseph Krogh
Subject Sv: autovacuum failing on pg_largeobject and disk usage of thepg_largeobject growing unchecked
Date
Msg-id VisenaEmail.74.9d4616d0a8a39a38.172befd99f2@tc7-visena
Whole thread Raw
In response to autovacuum failing on pg_largeobject and disk usage of the pg_largeobjectgrowing unchecked  ("Jim Hurne" <jhurne@us.ibm.com>)
Responses Re: Sv: autovacuum failing on pg_largeobject and disk usage of thepg_largeobject growing unchecked
List pgsql-general
Tree view
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 by date:

Previous
From: Michael Lewis
Date:
Subject: Re: autovacuum failing on pg_largeobject and disk usage of thepg_largeobject growing unchecked
Next
From: Eugene Pazhitnov
Date:
Subject: Re: pg_repack: WARNING: relation must have a primary key or not-nullunique keys