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 <cja...@emolecules.com>: > 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 >
