Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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



pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group