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

[Andreas Joseph Krogh <andreas@xxxxxxxxxx>]

På tirsdag 16. juni 2020 kl. 17:59:37, skrev Jim Hurne <jhurne@xxxxxxxxxx>:

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