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 8E8795638A for ; Fri, 25 Feb 2005 16:19:52 +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 14607-09 for ; Fri, 25 Feb 2005 16:19:45 +0000 (GMT) Received: from flake.decibel.org (flake.decibel.org [66.143.173.58]) by svr1.postgresql.org (Postfix) with ESMTP id 9368856394 for ; Fri, 25 Feb 2005 16:19:44 +0000 (GMT) Received: by flake.decibel.org (Postfix, from userid 1001) id 9EC1D1C902; Fri, 25 Feb 2005 10:20:05 -0600 (CST) Date: Fri, 25 Feb 2005 10:20:05 -0600 From: "Jim C. Nasby" To: Tom Lane Cc: Bruno Almeida do Lago , 'Michael Adler' , pgsql-performance@postgresql.org Subject: Re: Peformance Tuning Opterons/ Hard Disk Layout Message-ID: <20050225162005.GK84483@decibel.org> References: <421cca80.3da18bb5.6940.3b12@smtp.gmail.com> <21021.1109183848@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <21021.1109183848@sss.pgh.pa.us> X-Operating-System: FreeBSD 4.10-RELEASE-p3 i386 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.02 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200502/363 X-Sequence-Number: 10692 On Wed, Feb 23, 2005 at 01:37:28PM -0500, Tom Lane wrote: > "Bruno Almeida do Lago" writes: > > Is there a real limit for max_connections? Here we've an Oracle server with > > up to 1200 simultaneous conections over it! > > [ shrug... ] If your machine has the beef to run 1200 simultaneous > queries, you can set max_connections to 1200. > > The point of what you were quoting is that if you want to service > 1200 concurrent users but you only expect maybe 100 simultaneously > active queries from them (and you have a database box that can only > service that many) then you want to put a connection pooler in > front of 100 backends, not try to start a backend for every user. > > Oracle may handle this sort of thing differently, I dunno. > > regards, tom lane Oracle has some form of built-in connection pooling. I don't remember the exact details of it off the top of my head, but I think it was a 'wedge' that clients would connect to as if it was the database, and the wedge would then find an available database process to use. -- Jim C. Nasby, Database Consultant decibel@decibel.org Give your computer some brain candy! www.distributed.net Team #1828 Windows: "Where do you want to go today?" Linux: "Where do you want to go tomorrow?" FreeBSD: "Are you guys coming, or what?"