Re: Determine unused / not referenced large Objects

Tobias Meyer, 28.11.2012 10:02:
> Hello list,
>
> we have a database with several tables containing blobs (as oid),
> that reference large objects in pg_largeobject.
>
> It is my understanding, that the large objects will not be deleted if
> a row containing the oid is deleted – you have to do that yourself in
> application logic. (please correct me if wrong)
>
> I think we might not have done that consistently in the past.
>
> Is it safe to assume that pg_largeobject only contains large objects
> added by application code, or might there be any postgresql-internal
> objects?
>

Isn't vacuumlo supposed to do this kind of cleanup?

http://www.postgresql.org/docs/current/static/vacuumlo.html

Regards
Thomas