Re: Stats collector constant I/O

On May 14, 2014 9:19 PM, "Craig James" <cjames(at)emolecules(dot)com> wrote:
>
> Day and night, the postgres stats collector process runs at about 20
MB/sec output. vmstat shows this:
>
> $ vmstat 2
> procs -----------memory---------- ---swap-- -----io---- -system--
----cpu----
> r b swpd free buff cache si so bi bo in cs us sy
id wa
> 0 0 55864 135740 123804 10712928 4 6 445 2642 0 0 5 1
92 2
> 1 0 55864 134820 123804 10713012 0 0 0 34880 540 338 1 1
98 0
> 0 0 55864 135820 123812 10712896 0 0 0 20980 545 422 1 1
98 0
>
> iotop(1) shows that it's the stats collector, running at 20 MB/sec.

This is normal for 9.2 and below if you have hundreds of databases in the
cluster.

Cheers,

Jeff