Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 75D5E9FB4D1 for ; Thu, 1 Mar 2007 01:25:45 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 63355-02 for ; Thu, 1 Mar 2007 01:25:41 -0400 (AST) X-Greylist: delayed 00:06:39.107161 by SQLgrey-1.7.4 Received: from web7714.mail.in.yahoo.com (web7714.mail.in.yahoo.com [202.86.4.52]) by postgresql.org (Postfix) with SMTP id 6EDE99FB488 for ; Thu, 1 Mar 2007 01:25:41 -0400 (AST) Received: (qmail 65920 invoked by uid 60001); 1 Mar 2007 05:18:59 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.co.in; h=Message-ID:X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=uUgcfz1r1uiTKxAsEHazAjY2jpELvEhUGPmMTKG+9NixcV+IoI5CzsU2idhuiIRHRD+r0Czmz1QItuu/i/+FSkLl54tBJdwTGwAh98b8dkox9052d6BvnMQc6KdhuhNAyMevgdwM4tVoPZHPERJRDgwjx2qb8j59bt5581XX52A= ; Message-ID: <20070301051859.65918.qmail@web7714.mail.in.yahoo.com> X-YMail-OSG: 2c8HFQkVM1mXpSKhc.ItzMUIKEnaqccolyhabxXMjsixng098C.QF6.ZCsWfKIZREcVP_8VB3FGdPpLp85ynE2MW3Ut22UYDDFsVWx.j2MSMaWJNCk12Y1vsrWME6wQ- Received: from [203.197.22.83] by web7714.mail.in.yahoo.com via HTTP; Thu, 01 Mar 2007 05:18:59 GMT Date: Thu, 1 Mar 2007 05:18:59 +0000 (GMT) From: Shiva Sarna Subject: increasing database connections To: pgsql-performance@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-529758541-1172726339=:65139" Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/1 X-Sequence-Number: 23406 --0-529758541-1172726339=:65139 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Hi, I am sorry if it is a repeat question but I want to know if database performance will decrease if I increase the max-connections to 2000. At present it is 100. I have a requirement where the clent want 2000 simultaneous users and the only option we have now is to in crease the database connection but I am unale to find any document which indicates that this is a good or a bad practise. thanks for your help and time. regards shiva --------------------------------- Here’s a new way to find what you're looking for - Yahoo! Answers --0-529758541-1172726339=:65139 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Hi,

I am sorry if it is a repeat question but I want to know if database performance will decrease if I increase the max-connections to 2000. At present it is 100.

I have a requirement where the clent want 2000 simultaneous users and the only option we have now is to in crease the database connection but I am unale to find any document which indicates that this is a good or a bad practise.

thanks for your help and time.

regards

shiva


Here’s a new way to find what you're looking for - Yahoo! Answers --0-529758541-1172726339=:65139--