Thread: pgsql 7.4.8 : vacuum and blobs ?

Hello,
I had a large DB (db1) 12 GB using Blobs. To remvoe old large objects I
connected to db1 and did a <vacuum full analyse>. But the database size
is still 12GB.

How can I clan lod blobs from database ?

Thanks

FM <dist-list@LEXUM.UMontreal.CA> writes:
> How can I clan lod blobs from database ?

LOs don't go away just because they aren't referenced anywhere;
an explicit delete has to be issued.

You probably want to use contrib/vacuumlo.

            regards, tom lane