does vacuumlo removes BLOBs from deleted tables?

From: Irina Sourikova <irina(at)bnl(dot)gov>
To: pgsql-admin(at)postgresql(dot)org
Subject: does vacuumlo removes BLOBs from deleted tables?
Date: 2007-10-18 15:25:48
Message-ID: 47177AFC.3070907@bnl.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)bnl(dot)gov

Browse pgsql-admin by date

  From Date Subject
Next Message Anibal David Acosta 2007-10-18 15:29:28 Cycling redundancy check error in dump file
Previous Message Alexander Stanier 2007-10-18 14:56:38 Moving multiple schemas when upgrading from 8.1 to 8.2