| From: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Vince Lasmarias <vincent(dot)lasmarias(at)gmail(dot)com>, postgres performance list <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: High CPU load when 'free -m' shows low 'free' memory even though large 'cached' memory still available |
| Date: | 2014-06-05 20:03:46 |
| Message-ID: | CAHyXU0xYHOKKW2XcxvhVUH3i6Fwpa9Toxm64Gq68Rhf64iZYDQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Thu, Jun 5, 2014 at 8:47 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Vince Lasmarias <vincent(dot)lasmarias(at)gmail(dot)com> 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 is probably
> the culprit.
OP double posted this (OP: please refrain from doing that). I'm not
sure if THP is the issue here (although it is definitely a major
bugaboo if not a disaster IMNSHO) -- see commentary on the 'other
thread'.
http://www.postgresql.org/message-id/1401928047200-5806122.post@n5.nabble.com
melrin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Igor Neyman | 2014-06-05 20:20:57 | Re: Seqscan on big table, when an Index-Usage should be possible |
| Previous Message | Merlin Moncure | 2014-06-05 19:57:13 | Re: CPU load spikes when CentOS tries to reclaim 'cached' memory |