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

From Pavel Stehule
Subject Re: Stats collector constant I/O
Date
Msg-id CAFj8pRC9BZLbDftbTuAU74ZiPuSHsyXqWjhc+xGwpYztX4vOwg@mail.gmail.com
Whole thread Raw
In response to Stats collector constant I/O  (Craig James <cjames@emolecules.com>)
List pgsql-performance
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@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

pgsql-performance by date:

Previous
From: Jeff Janes
Date:
Subject: Re: Stats collector constant I/O
Next
From: 楊新波
Date:
Subject: Re: FW: how do functions affect query plan?