Re: [GENERAL] Fwd: Help!Why CPU Usage and LoadAverage Jump up Suddenly

2013-12-06 Thread John R Pierce
On 12/6/2013 11:04 AM, 吕晓旭 wrote: I find something with top : CPU usage of each postgres process is not so high when low concurrency, the highest one is about 50%. but when concurrency gradually increased, some postgres process cpu usage reach 100%, and keep a moment. and at these high concurren

Re: [GENERAL] Fwd: Help!Why CPU Usage and LoadAverage Jump up Suddenly

2013-12-06 Thread 吕晓旭
there are several reason drive us to build ourselves rpm, the most important is we want to install it in a directory self definition and another reason is setting CFLAGS(add -mavx for example, high light at previous ). because, without this compile parameter, response time is suffering on dell m

Re: [GENERAL] Fwd: Help!Why CPU Usage and LoadAverage Jump up Suddenly

2013-12-05 Thread John R Pierce
On 12/5/2013 12:46 AM, 吕晓旭 wrote: We find so weird problem on our productive PostgreSQL system. And I don't know how could I do to resolve this problem. We deployed PostgreSQL 9.2.4 on two system environments, and the performances between them are absolutely different. one of them it's

[GENERAL] Re: [GENERAL] Re: [GENERAL] Fwd: Help!Why CPU Usage and LoadAverage Jump up Suddenly

2013-12-05 Thread Matt Daw
Is khugepaged running during the stalls? http://www.postgresql.org/message-id/20130716195834.8fe5c79249cb2ff0d4270...@yahoo.es Matt On Thu, Dec 5, 2013 at 7:44 AM, Scott Marlowe wrote: > On Thu, Dec 5, 2013 at 1:46 AM, 吕晓旭 wrote: >> >> >> >> Hi, all >> We find so weird problem on our produc

[GENERAL] Re: [GENERAL] Fwd: Help!Why CPU Usage and LoadAverage Jump up Suddenly

2013-12-05 Thread Scott Marlowe
On Thu, Dec 5, 2013 at 1:46 AM, 吕晓旭 wrote: > > > > Hi, all > We find so weird problem on our productive PostgreSQL system. And I don't > know how could I do to resolve this problem. > We deployed PostgreSQL 9.2.4 on two system environments, and the > performances between them are absolu