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