How to delete large objects in postgres

Question

Should I call lo_unlink? Deletion did not delete the object from pg_largeobject.

Answer 1

Yes, you need to explicitly call lo_unlink (). I assume that you are just DELETEd the string that contained the link to it, and this will not delete the actual large object.

If you only refer to it from the same place, you can always create a trigger to do this automatically for you.

Answer 2

You can also clear large objects from the command line using

$ vacuumlo -U username databasename