Re: Occasional giant spikes in CPU load

From: Rajesh Kumar Mallah <mallah(dot)rajesh(at)gmail(dot)com>
To: Craig James <craig_james(at)emolecules(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Occasional giant spikes in CPU load
Date: 2010-06-25 16:07:03
Message-ID: AANLkTikVU058oRUXZcuaImYO0KpDN_zrawoUwgNrX1zn@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Dear Criag,

also check for the possibility of installing sysstat in our system.
it goes a long way in collecting the system stats. you may
consider increasing the frequency of data collection by
changing the interval of cron job manually in /etc/cron.d/
normally its */10 , you may make it */2 for time being.
the software automatically maintains historical records
of data for 1 month.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Craig James 2010-06-25 16:16:57 Re: Occasional giant spikes in CPU load
Previous Message Rajesh Kumar Mallah 2010-06-25 15:59:21 Re: sudden spurt in swap utilization (was:cpu bound postgresql setup.)