X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 15DAD56385 for ; Thu, 24 Feb 2005 03:50:10 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 62914-05 for ; Thu, 24 Feb 2005 03:50:03 +0000 (GMT) Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.250.190.2]) by svr1.postgresql.org (Postfix) with ESMTP id E983A5637F for ; Thu, 24 Feb 2005 03:50:02 +0000 (GMT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 62CCA31DE7; Thu, 24 Feb 2005 04:50:07 +0100 (MET) From: Christopher Browne X-Newsgroups: pgsql.performance Subject: Re: Peformance Tuning Opterons/ Hard Disk Layout Date: Wed, 23 Feb 2005 22:24:57 -0500 Organization: cbbrowne Computing Inc Lines: 29 Message-ID: References: <20050223180338.GA4259@pobox.com> <421cca80.3da18bb5.6940.3b12@smtp.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org X-message-flag: Outlook is rather hackable, isn't it? X-Home-Page: http://www.cbbrowne.com/info/ X-Affero: http://svcs.affero.net/rm.php?r=cbbrowne User-Agent: Gnus/5.1007 (Gnus v5.10.7) XEmacs/21.4 (Jumbo Shrimp, linux) Cancel-Lock: sha1:3hYVTJqzVZ0/ZWwj6/BoJtsam+Y= To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.114 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200502/346 X-Sequence-Number: 10675 teolupus@gmail.com ("Bruno Almeida do Lago") wrote: > Is there a real limit for max_connections? Here we've an Oracle server with > up to 1200 simultaneous conections over it! > > "max_connections: exactly like previous versions, this needs to be set to > the actual number of simultaneous connections you expect to need. High > settings will require more shared memory (shared_buffers). As the > per-connection overhead, both from PostgreSQL and the host OS, can be quite > high, it's important to use connection pooling if you need to service a > large number of users. For example, 150 active connections on a medium-end > 32-bit Linux server will consume significant system resources, and 600 is > about the limit." Right now, I have an Opteron box with: a) A load average of about 0.1, possibly less ;-), and b) 570 concurrent connections. Having so connections is something of a "fool's errand," as it really is ludicrously unnecessary, but I wouldn't be too afraid of having 1000 connections on that box, as long as they're being used for relatively small transactions. You can, of course, kill performance on any not-outrageously-large system if a few of those users are doing big queries... -- wm(X,Y):-write(X),write('@'),write(Y). wm('cbbrowne','gmail.com'). http://cbbrowne.com/info/slony.html I've had a perfectly wonderful evening. But this wasn't it. -- Groucho Marx