Re: Sudden slow down and spike in system CPU causes max_connections to get exhausted - Mailing list pgsql-general

From John R Pierce
Subject Re: Sudden slow down and spike in system CPU causes max_connections to get exhausted
Date
Msg-id 52CB68C6.4050101@hogranch.com
Whole thread Raw
In response to Sudden slow down and spike in system CPU causes max_connections to get exhausted  ("Anand Kumar, Karthik" <Karthik.AnandKumar@classmates.com>)
Responses Re: Sudden slow down and spike in system CPU causes max_connections to get exhausted  ("Anand Kumar, Karthik" <Karthik.AnandKumar@classmates.com>)
List pgsql-general
On 1/6/2014 5:06 PM, Anand Kumar, Karthik wrote:
> We run postgres 9.1.11, on Centos 6.3, and an ext2 filesystem

also, centos 6.3 is a couple year old release, you really should `yum
update` and get the latest centos 6.everything.   been lots and lots of
fixes between 6.3 and now (6.5 was the last released build, plus a
couple months of incremental patches to that).

lets see...  6.3 was released with kernel-2.6.32-279.el6.x86_64.rpm in
June 2012
6.5 came with kernel-2.6.32-431.el6.x86_64.rpm in November 2013
and the latest update is kernel-2.6.32-431.1.2.0.1.el6.x86_64.rpm





--
john r pierce                                      37N 122W
somewhere on the middle of the left coast



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Sudden slow down and spike in system CPU causes max_connections to get exhausted
Next
From: Keith Fiske
Date:
Subject: Re: replicate per tablespace