MIME-Version: 1.0
From: Artem Tomyuk <admin@leboutique.com>
Date: Wed, 2 Mar 2016 17:25:10 +0200
Message-ID: 
 <CANYYVq+vJ+8ZUm-jGVXd=Y4vPBKhd0R72nNtY-3tFYJ81YWPwQ@mail.gmail.com>
Subject: autovacuum disk IO
To: pgsql-admin@postgresql.org, pgsql-performance@postgresql.org
Content-Type: multipart/alternative; boundary=001a114b2f32f6439f052d127d99
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

--001a114b2f32f6439f052d127d99
Content-Type: text/plain; charset=UTF-8

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: 1
	pages: 0 removed, 263307 remain
	tuples: 298 removed, 1944753 remain, 0 are dead but not yet removable
	buffer usage: 67814 hits, 265465 misses, 15647 dirtied
	avg read rate: 3.183 MB/s, avg write rate: 0.188 MB/s
	*system 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.

--001a114b2f32f6439f052d127d99
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi.=C2=A0<div><br></div><div>I&#39;ve noticed that autovac=
. process worked more than 10 minutes, during this zabbix logged more than =
90% IO disk utilization on db volume....</div><div><br></div><div><pre styl=
e=3D"color:rgb(0,0,0);word-wrap:break-word;white-space:pre-wrap">=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D&gt;29237   2016-03-02 15:17:23 EET 00000 [24-1]LOG=
:  automatic vacuum of table &quot;lb_upr.public._reference32&quot;: index =
scans: 1
	pages: 0 removed, 263307 remain
	tuples: 298 removed, 1944753 remain, 0 are dead but not yet removable
	buffer usage: 67814 hits, 265465 misses, 15647 dirtied
	avg read rate: 3.183 MB/s, avg write rate: 0.188 MB/s
	<b>system usage: CPU 5.34s/6.27u sec elapsed 651.57 sec</b></pre>Is it pos=
sible to log autovac. io impact during it execution?</div><div>Is there any=
 way to limit or &quot;nice&quot; autovac. process?</div><div><br></div><di=
v>Thanks to all for any help.=C2=A0</div><div><br></div></div>

--001a114b2f32f6439f052d127d99--