SEO

#1 (**permalink**) 04-10-2008, 12:52 AM

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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

#2 (**permalink**) 04-10-2008, 12:52 AM

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

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

pgsql 7.4.8 : vacuum and blobs ?