Postgres Pro
Downloads
Home   >   mailing lists

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

From Jim Hurne
Subject Re: Sv: autovacuum failing on pg_largeobject and disk usage of thepg_largeobject growing unchecked
Date
Msg-id OF3DF1DF08.87AFFCF7-ON8525858A.0050A459-8525858A.0050D38F@notes.na.collabserv.com
Whole thread Raw
In response to Sv: autovacuum failing on pg_largeobject and disk usage of thepg_largeobject growing unchecked  (Andreas Joseph Krogh <andreas@visena.com>)
List pgsql-general
Tree view 
> 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 by date:

Previous
From: Toomas Kristin
Date:
Subject: Re: Conflict with recovery on PG version 11.6
Next
From: Tom Lane
Date:
Subject: Re: Importing a Large .ndjson file