Postgres Pro
Downloads
Home   >   mailing lists

Re: pgsql 7.4.8 : vacuum and blobs ? - Mailing list pgsql-admin

From Tom Lane
Subject Re: pgsql 7.4.8 : vacuum and blobs ?
Date
Msg-id 13811.1117467659@sss.pgh.pa.us
Whole thread Raw
In response to pgsql 7.4.8 : vacuum and blobs ?  (FM <dist-list@LEXUM.UMontreal.CA>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: FM
Date:
Subject: pgsql 7.4.8 : vacuum and blobs ?
Next
From: rohan rasane
Date:
Subject: Starting postgres server second time using admin rights...