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