Re: Stats collector constant I/O

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hello

we had similar issue - you can try to move statfile to ramdisc

http://serverfault.com/questions/495057/too-much-i-o-generated-by-postgres-stats-collector-process

Regards

Pavel Stehule


2014-05-15 6:18 GMT+02:00 Craig James <cjames@xxxxxxxxxxxxxx>:
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


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux