contrib/vacuumlo perhaps?
Michael Fuhr wrote:
> On Sat, Mar 04, 2006 at 12:08:52PM +0530, Md.Abdul Aziz wrote:
>> I am a presently working on a module which enhances postgre to
>> store audio files,while storing the aduido file in the databese i used
>> liod,now the problem is i am able to unlink but still the data is
>> present in the postgre database.can some one suggest me how to delete (not
>> unlink) large objects from the postgre databse.
>
> "VACUUM FULL pg_largeobject" might be what you're looking for, but
> if you're going to reload the data then an ordinary VACUUM (without
> FULL) will free the space for re-use by PostgreSQL without shrinking
> the file (unless the table has no live tuples, in which case the
> file size will be zeroed).
>