Re: [PERFORM] High CPU load when 'free -m' shows low 'free' memory even though large 'cached' memory still available

2014-06-05 Thread Merlin Moncure
On Thu, Jun 5, 2014 at 8:47 AM, Tom Lane wrote: > Vince Lasmarias writes: >> For the past few days, we've been seeing unexpected high CPU spikes in our >> system. > > Recent reports have suggested that disabling transparent huge page > management in your kernel can help with this. If the excess

Re: [PERFORM] High CPU load when 'free -m' shows low 'free' memory even though large 'cached' memory still available

2014-06-05 Thread Tom Lane
Vince Lasmarias writes: > For the past few days, we've been seeing unexpected high CPU spikes in our > system. Recent reports have suggested that disabling transparent huge page management in your kernel can help with this. If the excess CPU load is mostly "system" time not "user" time then this

[PERFORM] High CPU load when 'free -m' shows low 'free' memory even though large 'cached' memory still available

2014-06-04 Thread Vince Lasmarias
For the past few days, we've been seeing unexpected high CPU spikes in our system. We observed the following: - every single CPU spike was preceded by low 'free' memory even though 'cached' is quite high - as soon as we shut down any of our applications which is occupying some DB connections (e.g.