does vacuumlo removes BLOBs from deleted tables?

Поиск
Список
Период
Сортировка
Искать

does vacuumlo removes BLOBs from deleted tables?

От:
Irina Sourikova <irina@bnl.gov>
Дата:
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


Re: does vacuumlo removes BLOBs from deleted tables?

От:
Irina Sourikova <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


FAQ