Postgres Pro
Downloads
Home   >   mailing lists

does vacuumlo removes BLOBs from deleted tables? - Mailing list pgsql-admin

From Irina Sourikova
Subject does vacuumlo removes BLOBs from deleted tables?
Date
Msg-id 47177AFC.3070907@bnl.gov
Whole thread Raw
List pgsql-admin
Tree view 
Hi,

All tables in our database have a column of 'lo' type that stores the BLOBs.
After deleting 10 old big tables I ran vacuumlo to remove the old BLOBs,
but no large object was removed.
We run version 8.2

Any advice is greatly appreciated.

Thank you,
Irina

--
Irina Sourikova
Brookhaven National Laboratory      phone: +1-631-344-3776
Physics Department, Bldg 510 C      fax:   +1-631-344-3253
Upton, NY 11973-5000                email: irina@bnl.gov

pgsql-admin by date:

Previous
From: "Peter Koczan"
Date:
Subject: Re: convert char to varchar
Next
From: Alexander Stanier
Date:
Subject: Moving multiple schemas when upgrading from 8.1 to 8.2