public inbox for [email protected]
help / color / mirror / Atom feedFrom: Pavel Stehule <[email protected]>
To: Artem Tomyuk <[email protected]>
Cc: pgsql-admin <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: [PERFORM] autovacuum disk IO
Date: Wed, 2 Mar 2016 16:31:15 +0100
Message-ID: <CAFj8pRBkF6qq=A7GnyNNvP6vWzb=WdtcEQpUUyL+12o_Ccx2aA@mail.gmail.com> (raw)
In-Reply-To: <CANYYVq+vJ+8ZUm-jGVXd=Y4vPBKhd0R72nNtY-3tFYJ81YWPwQ@mail.gmail.com>
References: <CANYYVq+vJ+8ZUm-jGVXd=Y4vPBKhd0R72nNtY-3tFYJ81YWPwQ@mail.gmail.com>
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgsql-admin>
Hi
2016-03-02 16:25 GMT+01:00 Artem Tomyuk <[email protected]>:
> 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.
>
>
maybe offtopic - there is known problem of Zabbix. Any limits for vacuum
are usually way to hell.
But more times the partitioning helps to Zabbix
https://www.zabbix.org/wiki/Higher_performant_partitioning_in_PostgreSQL
Regards
Pavel
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: [PERFORM] autovacuum disk IO
In-Reply-To: <CAFj8pRBkF6qq=A7GnyNNvP6vWzb=WdtcEQpUUyL+12o_Ccx2aA@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox