X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 464F4D1D82F for ; Wed, 14 Jan 2004 13:02:43 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 97148-09 for ; Wed, 14 Jan 2004 09:02:15 -0400 (AST) Received: from smtp.pspl.co.in (www.pspl.co.in [202.54.11.65]) by svr1.postgresql.org (Postfix) with ESMTP id 40B30D1B4A7 for ; Wed, 14 Jan 2004 09:02:06 -0400 (AST) Received: (from root@localhost) by smtp.pspl.co.in (8.12.9/8.12.9) id i0ED2Ib2006808 for ; Wed, 14 Jan 2004 18:32:18 +0530 Received: from daithan.intranet.pspl.co.in (daithan.intranet.pspl.co.in [192.168.7.161]) (authenticated bits=0) by persistent.co.in (8.12.9/8.12.9) with ESMTP id i0ED2H1E006795 for ; Wed, 14 Jan 2004 18:32:17 +0530 From: Shridhar Daithankar To: pgsql-performance@postgresql.org Subject: Re: 100 simultaneous connections, critical limit? Date: Wed, 14 Jan 2004 18:31:00 +0530 User-Agent: KMail/1.5.4 References: <40053A91.5060001@physicallink.com> In-Reply-To: <40053A91.5060001@physicallink.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Disposition: inline Message-Id: <200401141831.00453.shridhar_daithankar@persistent.co.in> Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by persistent.co.in id i0ED2H1E006795 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/138 X-Sequence-Number: 5313 On Wednesday 14 January 2004 18:18, Jón Ragnarsson wrote: > 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? Yes. You should rather investigate connection pooling. I am no php expert but probably this could help you.. http://www.php.net/manual/en/function.pg-pconnect.php Shridhar