Search Postgresql Archives
Gigantic load average spikes
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
- Subject: Gigantic load average spikes
- From: rihad <rihad@xxxxxxx>
- Date: Sun, 31 Mar 2019 19:23:11 +0400
- User-agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.8.0
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
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.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]