Slightly faster version of vacuumlo

Поиск
Список
Период
Сортировка
Искать
От
Denis Perchine
Тема
Slightly faster version of vacuumlo
Дата
Msg-id
00060714445102.00505@dyp
Список
Hello all,

I tried to use vacuumlo on quite big database with large objects (approx 20000-30000).
And I found out that it will take 5-6 hours to cleanup blobs even when there's no unlinked ones.
I've looked inside the code and added some improvements.
Now it took 20-30 seconds to complete.

-- 
Sincerely Yours,
Denis Perchine

----------------------------------
E-Mail: dyp@perchine.com
HomePage: http://www.perchine.com/dyp/
FidoNet: 2:5000/120.5
----------------------------------
В списке pgsql-hackers по дате отправления
От: Tom Lane
Дата:
Сообщение: Re: Use of system indexes
От: Hannu Krosing
Дата:
FAQ