X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 9649452B64 for ; Wed, 27 Jul 2005 01:00:55 -0300 (ADT) 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 17773-08 for ; Wed, 27 Jul 2005 04:00:46 +0000 (GMT) Received: from mr1.surnet.cl (smtp1.surnet.cl [216.155.73.162]) by svr1.postgresql.org (Postfix) with ESMTP id 8F22852A37 for ; Wed, 27 Jul 2005 01:00:44 -0300 (ADT) Received: from smtp1.surnet.cl (216.155.73.168) by mr1.surnet.cl (7.0.031.3) id 42587EDE01856184; Wed, 27 Jul 2005 00:00:03 -0400 Received: from smtp1.surnet.cl (mr1.surnet.cl []) by mr1.surnet.cl ([216.155.73.168]); Wed, 27 Jul 2005 04:00:03 +0000 Received: from cluster.surnet.cl (216.155.73.164) by smtp1.surnet.cl (7.0.031.3) id 42587C6E01287047; Wed, 27 Jul 2005 00:00:02 -0400 Received: from alvh.no-ip.org (200.85.218.66) by cluster.surnet.cl (7.0.043) (authenticated as alvherre@surnet.cl) id 42B3EF6000573D94; Wed, 27 Jul 2005 00:00:40 -0400 Received: by alvh.no-ip.org (Postfix, from userid 1000) id 29B22C2D450; Wed, 27 Jul 2005 00:01:34 -0400 (CLT) Date: Wed, 27 Jul 2005 00:01:34 -0400 From: Alvaro Herrera To: Halley Pacheco de Oliveira Cc: pgsql-docs@postgresql.org, Roman Neuhauser Subject: Re: PostgreSQL 8.0.3 Documentation - Chapter 23. Monitoring Database Activity Message-ID: <20050727040134.GH20145@alvh.no-ip.org> References: <20050726194901.GA56282@isis.sigpipe.cz> <20050727011712.64392.qmail@web52709.mail.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <20050727011712.64392.qmail@web52709.mail.yahoo.com> User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.414 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, FORGED_RCVD_HELO, RCVD_IN_NJABL_PROXY X-Spam-Level: * X-Archive-Number: 200507/31 X-Sequence-Number: 3157 On Tue, Jul 26, 2005 at 10:17:12PM -0300, Halley Pacheco de Oliveira wrote: > The surprise is: > > Oracle - MTS - Multi-Threaded-Server - MTS allows many user processes > to share very few server processes. Without MTS, each user process > requires its own dedicated server process; a new server process is > created for each client requesting a connection. A dedicated server > process remains associated to the user process for the remainder of > the connection. With MTS many user processes connect to a dispatcher > process. The dispatcher routes client requests to the next available > shared server process. The advantage of MTS is that system overhead is > reduced, so the number of users that can be supported is increased. Hmm, seems a very similar thing can be had in Postgres by means of pgpool. It'd be interesting to see how are cursors handled, or any other long-lived session-local resources for that matter, by this dispatcher process of Oracle's. -- Alvaro Herrera () "Crear es tan difícil como ser libre" (Elsa Triolet)