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