Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 58A2C9FB33A for ; Thu, 1 Mar 2007 07:04:30 -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 96634-09 for ; Thu, 1 Mar 2007 07:04:22 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mx01.bfk.de (mx01.bfk.de [193.227.124.2]) by postgresql.org (Postfix) with ESMTP id 9AF959FB2BA for ; Thu, 1 Mar 2007 07:04:26 -0400 (AST) Received: from mx00.int.bfk.de ([10.119.110.2]) by mx01.bfk.de with esmtps (TLS-1.0:RSA_AES_256_CBC_SHA1:32) id 1HMj4x-0000lK-Kv; Thu, 01 Mar 2007 12:04:07 +0100 Received: from fweimer by bfk.de with local id 1HMj4t-00028J-R8; Thu, 01 Mar 2007 12:04:03 +0100 To: Mark Kirkwood Cc: "Joshua D. Drake" , "Jonah H. Harris" , Shiva Sarna , pgsql-performance@postgresql.org Subject: Re: increasing database connections References: <20070301051859.65918.qmail@web7714.mail.in.yahoo.com> <36e682920702282149y3529b175ob5814e3f957aec15@mail.gmail.com> <45E6702A.5060602@commandprompt.com> <45E67B9A.8030209@paradise.net.nz> From: Florian Weimer Date: Thu, 01 Mar 2007 12:04:03 +0100 In-Reply-To: <45E67B9A.8030209@paradise.net.nz> (Mark Kirkwood's message of "Thu, 01 Mar 2007 20:07:06 +1300") Message-ID: <82d53t8bto.fsf@mid.bfk.de> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.051 tagged_above=0 required=5 tests=AWL, BAYES_50 X-Spam-Level: X-Archive-Number: 200703/6 X-Sequence-Number: 23411 * Mark Kirkwood: > Yeah - I thought that somewhere closer to 10000 connections is where > you get hit with socket management related performance issues. Huh? These sockets aren't handled in a single process, are they? Nowadays, this number of sockets does not pose any problem for most systems, especially if you don't do I/O multiplexing. Of course, if you've got 10,000 connections which are active in parallel, most users won't be content with 1/10,000th of your database performance. 8-/ (I don't see why idle connections should be a problem from a socket management POV, though.) --=20 Florian Weimer BFK edv-consulting GmbH http://www.bfk.de/ Kriegsstra=DFe 100 tel: +49-721-96201-1 D-76133 Karlsruhe fax: +49-721-96201-99