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 3D0E58B9E80 for ; Wed, 23 Feb 2005 18:37:42 +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 92387-08 for ; Wed, 23 Feb 2005 18:37:39 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 9E4628B9E7A for ; Wed, 23 Feb 2005 18:37:38 +0000 (GMT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j1NIbSn5021022; Wed, 23 Feb 2005 13:37:28 -0500 (EST) To: "Bruno Almeida do Lago" Cc: "'Michael Adler'" , pgsql-performance@postgresql.org Subject: Re: Peformance Tuning Opterons/ Hard Disk Layout In-reply-to: <421cca80.3da18bb5.6940.3b12@smtp.gmail.com> References: <421cca80.3da18bb5.6940.3b12@smtp.gmail.com> Comments: In-reply-to "Bruno Almeida do Lago" message dated "Wed, 23 Feb 2005 15:26:18 -0300" Date: Wed, 23 Feb 2005 13:37:28 -0500 Message-ID: <21021.1109183848@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.007 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200502/332 X-Sequence-Number: 10661 "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