Performance of vacuumlo

Поиск
Список
Период
Сортировка
От Andreas Joseph Krogh
Тема Performance of vacuumlo
Дата
Msg-id VisenaEmail.4.d57421803d3cda2d.14cbabdcef9@tc7-visena
обсуждение исходный текст
Список pgsql-performance
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
Вложения

В списке pgsql-performance по дате отправления:

Предыдущее
От: Jim Nasby
Дата:
Сообщение: Re: unlogged tables
Следующее
От: Jon Dufresne
Дата:
Сообщение: extract(year from date) doesn't use index but maybe could?