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 AD8088B9CAD for ; Wed, 23 Feb 2005 18:36:22 +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 93394-02 for ; Wed, 23 Feb 2005 18:36:13 +0000 (GMT) Received: from tht.net (vista.tht.net [216.126.88.2]) by svr1.postgresql.org (Postfix) with ESMTP id 06A408B9B1B for ; Wed, 23 Feb 2005 18:36:13 +0000 (GMT) Received: from dyn-69-234.tor.dsl.tht.net (dyn-69-234.tor.dsl.tht.net [134.22.69.234]) by tht.net (Postfix) with ESMTP id 1531476A47; Wed, 23 Feb 2005 13:36:13 -0500 (EST) Subject: Re: Peformance Tuning Opterons/ Hard Disk Layout From: Rod Taylor To: Bruno Almeida do Lago Cc: 'Michael Adler' , Postgresql Performance In-Reply-To: <421cca80.3da18bb5.6940.3b12@smtp.gmail.com> References: <421cca80.3da18bb5.6940.3b12@smtp.gmail.com> Content-Type: text/plain Date: Wed, 23 Feb 2005 13:35:03 -0500 Message-Id: <1109183703.40753.196.camel@home> Mime-Version: 1.0 X-Mailer: Evolution 2.0.3 FreeBSD GNOME Team Port Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.017 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200502/331 X-Sequence-Number: 10660 On Wed, 2005-02-23 at 15:26 -0300, 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! If you can reduce them by using something like pgpool between PostgreSQL and the client, you'll save some headache. PostgreSQL did not perform as well with a large number of idle connections and it does otherwise (last time I tested was 7.4 though -- perhaps it's better now). The kernel also starts to play a significant role with a high number of connections. Some operating systems don't perform as well with a high number of processes (process handling, scheduling, file handles, etc.). I think you can do it without any technical issues, but you will probably be happier with the result if you can hide idle connections from the database machine. --