From: Christopher Browne <cbbrowne@acm.org>
To: pgsql-performance@postgresql.org
Subject: Re: 100 simultaneous connections, critical limit?
Date: Wed, 14 Jan 2004 08:27:03 -0500
Message-ID: <m3fzeilkyg.fsf@wolfe.cbbrowne.com> (raw)
References: <40053A91.5060001@physicallink.com>
Clinging to sanity, jonr@physicallink.com (Jón Ragnarsson) mumbled into her beard:
> I am writing a website that will probably have some traffic.
> Right now I wrap every .php page in pg_connect() and pg_close().
> Then I read somewhere that Postgres only supports 100 simultaneous
> connections (default). Is that a limitation? Should I use some other
> method when writing code for high-traffic website?
I thought the out-of-the-box default was 32.
If you honestly need a LOT of connections, you can configure the
database to support more. I "upped the limit" on one system to have
512 the other week; certainly supportable, if you have the RAM for it.
It is, however, quite likely that the connect()/close() cuts down on
the efficiency of your application. If PHP supports some form of
"connection pooling," you should consider using that, as it will cut
down _dramatically_ on the amount of work done establishing/closing
connections, and should let your apps use somewhat fewer connections
more effectively.
--
(format nil "~S@~S" "cbbrowne" "acm.org")
http://cbbrowne.com/info/linux.html
"It has been said that man is a rational animal. All my life I have
been searching for evidence which could support this."
-- Bertrand Russell
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: cbbrowne@acm.org
Subject: Re: 100 simultaneous connections, critical limit?
In-Reply-To: <m3fzeilkyg.fsf@wolfe.cbbrowne.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