autovacuum disk IO

Поиск
Список
Период
Сортировка
От Artem Tomyuk
Тема autovacuum disk IO
Дата
Msg-id CANYYVq+vJ+8ZUm-jGVXd=Y4vPBKhd0R72nNtY-3tFYJ81YWPwQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: [PERFORM] autovacuum disk IO
Re: [PERFORM] autovacuum disk IO
Re: autovacuum disk IO
Список pgsql-admin
Hi. 

I've noticed that autovac. process worked more than 10 minutes, during this zabbix logged more than 90% IO disk utilization on db volume....

===========>29237   2016-03-02 15:17:23 EET 00000 [24-1]LOG:  automatic vacuum of table "lb_upr.public._reference32": index scans: 1pages: 0 removed, 263307 remaintuples: 298 removed, 1944753 remain, 0 are dead but not yet removablebuffer usage: 67814 hits, 265465 misses, 15647 dirtiedavg read rate: 3.183 MB/s, avg write rate: 0.188 MB/ssystem usage: CPU 5.34s/6.27u sec elapsed 651.57 sec
Is it possible to log autovac. io impact during it execution?
Is there any way to limit or "nice" autovac. process?

Thanks to all for any help. 

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

Предыдущее
От: Guillaume Lelarge
Дата:
Сообщение: Re: To avoid a database shutdown, execute a database-wide VACUUM
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: [PERFORM] autovacuum disk IO