On Tue, Oct 10, 2017 at 01:40:07PM -0700, pinker wrote:
> Hi to all!
>
> We've got problem with a very serious repetitive incident on our core
> system. Namely, cpu load spikes to 300-400 and the whole db becomes
> unresponsive. From db point of view nothing special is happening, memory
> looks fine, disks io's are ok and the only problem is huge cpu load. Kernel
> parameters that are increasing with load are always the same:
> * disabled transparent huge pages (they were set before unfortunately to
> 'always')
Did you also try disabling KSM ?
echo 2 |sudo tee /sys/kernel/mm/ksm/run
I believe for us that was affecting a postgres VM(QEMU/KVM) and maybe not
postgres itself. Worth a try ?
https://www.postgresql.org/message-id/20170718180152.GE17566%40telsasoft.com
Justin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general