[GENERAL] Determine unused / not referenced large Objects

2012-11-28 Thread Tobias Meyer
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

Re: [GENERAL] Determine unused / not referenced large Objects

2012-11-28 Thread Thomas Kellerer
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

Re: [GENERAL] Determine unused / not referenced large Objects

2012-11-28 Thread Tobias Meyer
Isn't vacuumlo supposed to do this kind of cleanup? http://www.postgresql.org/docs/current/static/vacuumlo.html Regards Thomas Thank you - I wasn't aware of that utility program - just what I was looking for. Tobias -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To