Обсуждение: Performance of vacuumlo

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

Performance of vacuumlo

От
Andreas Joseph Krogh
Дата:
Hi all.
 
I have a pg_largeobject of ~300GB size and when I run "vacuumlo -n <dbname>", I get:
 
Would remove 82172 large objects from database "<dbname>".
 
So I'm running without "-n" to do the actual work, but it seems to take forever. The disks are 8 SAS 10K HDD drives in RAID5.
 
Any hints on how long this is supposed to take?
 
Thanks.
 
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
Вложения