Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WGkmR-0003XL-VO for pgsql-admin@arkaria.postgresql.org; Fri, 21 Feb 2014 07:44:21 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WGkmR-0006dS-9Y for pgsql-admin@arkaria.postgresql.org; Fri, 21 Feb 2014 07:44:19 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WGkmO-0006d8-P7 for pgsql-admin@postgresql.org; Fri, 21 Feb 2014 07:44:17 +0000 Received: from nm31.bullet.mail.ne1.yahoo.com ([98.138.229.24]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WGkmL-00064K-IZ for pgsql-admin@postgresql.org; Fri, 21 Feb 2014 07:44:16 +0000 Received: from [127.0.0.1] by nm31.bullet.mail.ne1.yahoo.com with NNFMP; 21 Feb 2014 07:44:12 -0000 Received: from [98.138.101.128] by nm31.bullet.mail.ne1.yahoo.com with NNFMP; 21 Feb 2014 07:41:26 -0000 Received: from [106.10.166.60] by tm16.bullet.mail.ne1.yahoo.com with NNFMP; 21 Feb 2014 07:41:25 -0000 Received: from [106.10.151.170] by tm17.bullet.mail.sg3.yahoo.com with NNFMP; 21 Feb 2014 07:41:25 -0000 Received: from [127.0.0.1] by omp1010.mail.sg3.yahoo.com with NNFMP; 21 Feb 2014 07:41:25 -0000 X-Yahoo-Newman-Property: ymail-4 X-Yahoo-Newman-Id: 232099.22478.bm@omp1010.mail.sg3.yahoo.com Received: (qmail 40700 invoked by uid 60001); 21 Feb 2014 07:41:25 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.co.in; s=s1024; t=1392968485; bh=4w27tWpi6H0OfEMlVftGbBBTSu+Mm36YriAuUJ+ofDE=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=W/DMl5c+fNh1Pt7NpFYW4WG46H64Ona0SBkF532DyKbb2uMjFVxdxCr0hzsw+nxUArSshul9tSWbXm/j7KGFFStYlCKYjw9QOuosUvX7xrPmRx4PR0TY5WpP0SS7iKWcHuxK0cWC5BSKbcnRsa3M3b72Ofn9GEHo4HUoENoMxgc= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.co.in; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=wBOVLPL+wJgd3ci8SeHrBJQLTqDVZ+ALz/v4uPddHM0JZpEO5KFuzx1wHzC6lmi5y6OQF6SN3WZPg6u2VwaZbEBiM7AocBOKmnbL3utTJb39zoqqkzt2RHc5lZK9X16Yk4fE6F12ZOvttmv4Q3YhrdtIUIb3Odykwy/h1BZMm9Y=; X-YMail-OSG: B0zyDGgVM1nsI4WCb18kpNcCSDj2vpIWr2x3vMWGGXlR4Tl UJuCGgLssBQ8sLLLfCJCoNRBTAzeTC8A4fQlNQ4G27kq323rXTxYNF8HJpld HdGgXjjqDYrGgOhW53QCrtn8udMlrFvUvlHrRN0DsmqKqwtd24fqIfol6D1B U5ttGqw9UL4pYx.vsZvsSOVEm.9VrzQ5xbaq7W5e8yNcm.yjkBrQBHPjsGs_ M65hysQe7JYD3pydMEhcOThuDMVXCwPuUwboNSE3viosZBhC75_fFutk2mdG KWObdHl14qANthpzlW9t9UPfDo8.HUVuZXbHB_xjNdoN5Qp1wyYTN57hXW76 cw.uUWsbxAiUt3Ep1WP8ZgRFqyN9PDeLUP_QCy5TYjqpDIinXCmfw66lDOq1 LPKytKMu0UK5pfwxT3l2SNyPgvrSYniwmxllJKzHjoLduItdH_11m1uo2wIx BgTJJYPB_9qB9yIDvGB8LCliwyjxfaVxaXXHvDRXsFTql.IaEf_LA8_ewu9B m6RzjwmsVono5fz.Ok3Rt0Z.82NNAy0yzhJp0A8xwi8V.gGYBJHyJcCR8dXG qMkIVGfN30nLXaaLsy3u0qQwGJMHqJcpH5Jpxi3NJk45Ed46Z0i1kHMIxjm9 aUDf1uB_SRnYZoHMNLUTZJK0o1GpQVm9t6Bm_9MEAVfOPgUC941Hg Received: from [218.248.37.146] by web190805.mail.sg3.yahoo.com via HTTP; Fri, 21 Feb 2014 15:41:24 SGT X-Rocket-MIMEInfo: 002.001, SW5jcmVhc2UgeW91ciBrZW5hbCBsZXZlbCBwYXJhbWV0ZXIuCmluIHRoZSAvZXRjL3N5c2N0bC5jb25mIGZpbGUKa2VybmFsLnNobW1heD0gCmtlcm5hbC5zaG1pbiA9IApiYXNlZCBvbiB5b3VyIFJBTSBtZW1vcnkuCkdpdmUgaGFsZiBvZiBSQU0gc2l6ZSB0byB0aGVzZSBwYXJhbWV0ZXIuCmNhbGN1bGF0ZSB0aGUgdmFsdWUgb2Yga2VybmFsLnNobW1heCwga2VybmFsLnNobWluIGZyb20gdGhlIGdpdmVuIGxpbmsuCmh0dHA6Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9jcy85LjIvc3RhdGljL2tlcm5lbC1yZXMBMAEBAQE- X-Mailer: YahooMailWebService/0.8.177.636 References: Message-ID: <1392968484.24487.YahooMailNeo@web190805.mail.sg3.yahoo.com> Date: Fri, 21 Feb 2014 15:41:24 +0800 (SGT) From: om prash jaiswal Reply-To: om prash jaiswal Subject: Re: Increasing maximum connection for postgresql 9.2 To: Amardeep Kaur , "pgsql-admin@postgresql.org" In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="-203761985-1100157086-1392968484=:24487" X-Pg-Spam-Score: -0.1 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org ---203761985-1100157086-1392968484=:24487 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Increase your kenal level parameter.=0Ain the /etc/sysctl.conf file=0Akerna= l.shmmax=3D =0Akernal.shmin =3D =0Abased on your RAM memory.=0AGive half of= RAM size to these parameter.=0Acalculate the value of kernal.shmmax, kerna= l.shmin from the given link.=0Ahttp://www.postgresql.org/docs/9.2/static/ke= rnel-resources.html#SYSVIPC.=0A=0A=0A=0A=0A=0AOn Friday, 21 February 2014 8= :06 AM, Amardeep Kaur wrote:=0A =0AHey Guys =0A= =0AI am trying to increase the max_connection from 100 to 5000. I modified = shared_buffer and changed kernel parameters according to =0Ahttp://www.post= gresql.org/docs/9.2/static/kernel-resources.html#SYSVIPC.=0AWhen i stress t= est it with 500 concurrent request, then after 150 - 160 concurrent connect= ions my database enters into recovery mode and it fails the request. For my= stress test i am trying to get data from one table. =0A=0ADo you guys have= any idea what is causing the problem or if i am missing some other configu= ration?=0A=0A=0A-- =0A=0AAmardeep Kaur ---203761985-1100157086-1392968484=:24487 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
Increase your kenal l= evel parameter.
in the /etc/sysctl.conf file
kernal.shmmax=3D
ker= nal.shmin =3D
based on your RAM memory.
Give half of RAM size to the= se parameter.
calculate the value of kernal.shmmax, kernal.shmin from th= e given link.
http://www.pos= tgresql.org/docs/9.2/static/kernel-resources.html#SYSVIPC.

=

On Friday, 21 February 2014 8:06 AM, Amardeep Kaur <amardeepka= ur88@gmail.com> wrote:
Hey Guys

I am tryin= g to increase the max_connection from 100 to 5000. I modified shared_buffer= and changed kernel parameters according to
http://www.postgresql.org/docs/9.2/static/kernel-resource= s.html#SYSVIPC.
=0A
When i stress test it with 500 concurrent r= equest, then after 150 - 160 concurrent connections my database enters into= recovery mode and it fails the request. For my stress test i am trying to = get data from one table.
=0A
Do you guys have any idea what i= s causing the problem or if i am missing some other configuration?

--
Amardeep Kaur

=0A


---203761985-1100157086-1392968484=:24487--