Postgres Pro
Downloads
Home   >   mailing lists

Re: increasing database connections - Mailing list pgsql-performance

From Jonah H. Harris
Subject Re: increasing database connections
Date
Msg-id 36e682920702282149y3529b175ob5814e3f957aec15@mail.gmail.com
Whole thread Raw
In response to increasing database connections  (Shiva Sarna <shivasarna@yahoo.co.in>)
Responses Re: increasing database connections  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: increasing database connections  (Magnus Hagander <magnus@hagander.net>)
List pgsql-performance
Tree view 
On 3/1/07, Shiva Sarna <shivasarna@yahoo.co.in> wrote:
> 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.

Most certainly.  Adding connections over 200 will degrade performance
dramatically.  You should look into pgpool or connection pooling from
the application.

--
Jonah H. Harris, Software Architect | phone: 732.331.1324
EnterpriseDB Corporation            | fax: 732.331.1301
33 Wood Ave S, 3rd Floor            | jharris@enterprisedb.com
Iselin, New Jersey 08830            | http://www.enterprisedb.com/

pgsql-performance by date:

Previous
From: Shiva Sarna
Date:
Subject: increasing database connections
Next
From: "Joshua D. Drake"
Date:
Subject: Re: increasing database connections