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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general