Обсуждение: does vacuumlo removes BLOBs from deleted tables?

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

Sorry to reply to my own post, all BLOBs had pointers from other tables.

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