From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | Craig James <cjames(at)emolecules(dot)com> |
Cc: | "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: Stats collector constant I/O |
Date: | 2014-05-15 08:25:34 |
Message-ID: | CAFj8pRC9BZLbDftbTuAU74ZiPuSHsyXqWjhc+xGwpYztX4vOwg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)emolecules(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | 楊新波 | 2014-05-15 08:31:10 | Re: FW: how do functions affect query plan? |
Previous Message | Jeff Janes | 2014-05-15 08:18:16 | Re: Stats collector constant I/O |