From: Joshua D. Drake <jd@commandprompt.com>
To: Magnus Hagander <magnus@hagander.net>
Cc: Jonah H. Harris <jonah.harris@gmail.com>
Cc: Shiva Sarna <shivasarna@yahoo.co.in>
Cc: pgsql-performance@postgresql.org
Subject: Re: increasing database connections
Date: Thu, 01 Mar 2007 07:47:28 -0800
Message-ID: <45E6F590.6040604@commandprompt.com> (raw)
In-Reply-To: <20070301085824.GB27639@svr2.hagander.net>
References: <20070301051859.65918.qmail@web7714.mail.in.yahoo.com>
<36e682920702282149y3529b175ob5814e3f957aec15@mail.gmail.com>
<20070301085824.GB27639@svr2.hagander.net>
Magnus Hagander wrote:
> On Thu, Mar 01, 2007 at 12:49:14AM -0500, Jonah H. Harris wrote:
>> 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.
>
> Are you sure? I've heard of at least one installation which runs with
> 5000+ connections, and it works fine.
We have one that high as well and it does fine. Although I wouldn't
suggest it on less than 8.1 ;). 8.2 handles it even better since 8.2
handles >8 cores better than 8.1.
Joshua D. Drake
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: jd@commandprompt.com, magnus@hagander.net, jonah.harris@gmail.com, shivasarna@yahoo.co.in
Subject: Re: increasing database connections
In-Reply-To: <45E6F590.6040604@commandprompt.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox