Postgres Pro
Downloads
Home   >   mailing lists

Stats collector constant I/O - Mailing list pgsql-performance

From Craig James
Subject Stats collector constant I/O
Date
Msg-id CAFwQ8rdBOt2EwyXrCZ=8W8xNq9CMR5QiMCDBzYh9eJC4kVf-nQ@mail.gmail.com
Whole thread Raw
Responses Re: Stats collector constant I/O  (Jeff Janes <jeff.janes@gmail.com>)
Re: Stats collector constant I/O  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: Stats collector constant I/O  (Tomas Vondra <tv@fuzzy.cz>)
List pgsql-performance
Tree view
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.

Is this normal?

Craig

pgsql-performance by date:

Previous
From: Jeff Janes
Date:
Subject: Re: CPU spikes and transactions
Next
From: 常超
Date:
Subject: how do functions affect query plan?