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

From: "Jim Hurne" <jhurne(at)us(dot)ibm(dot)com>
To: Andreas Joseph Krogh <andreas(at)visena(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Sv: autovacuum failing on pg_largeobject and disk usage of the pg_largeobject growing unchecked
Date: 2020-06-17 14:42:50
Message-ID: OF3DF1DF08.87AFFCF7-ON8525858A.0050A459-8525858A.0050D38F@notes.na.collabserv.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2020-06-17 15:18:21 Re: Importing a Large .ndjson file
Previous Message Toomas Kristin 2020-06-17 13:38:44 Re: Conflict with recovery on PG version 11.6