On 3/31/19 8:23 AM, rihad wrote:
Postgres 10.3 On freebsd 10.3 is almost idle, disk i/o about 5-10%,
number running processes about 1-3, cpu about 90% idle, then we run a
i/o heavy job like "refresh materialized view", cpu & disk i/o still not
maxed out, all of a sudden the number of running processes increases to
about 250-300 for a second, which increases load averages that we
Do you know what the processes are?
Are there any messages in the Postgres log from that time period that
might shed light?
periodically poll to see if everything's alright. Why is that? Disk i/o
is far from being maxed out, the actual number of running processes is
really small.
You are referring to the between spikes process count?
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
