Bernd Helmle <mailings(at)oopsware(dot)de> writes:
> Here you can find an excellent description, how BLOBs in PostgreSQL can
> be handled:
> http://www.varlena.com/varlena/GeneralBits/44.php
That's a good discussion, but it left out at least one useful bit of
info about managing large objects: there's a contrib utility
(contrib/vacuumlo) that can find and remove large objects that are not
referenced anywhere in the database. This is a good way to clean up
if you've been using large objects without any of the automatic
management techniques suggested in the GeneralBits article.
regards, tom lane