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 C52A23A5610 for ; Mon, 24 Jan 2005 23:48:34 +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 23391-07 for ; Mon, 24 Jan 2005 23:48:21 +0000 (GMT) Received: from davinci.ethosmedia.com (server227.ethosmedia.com [209.128.84.227]) by svr1.postgresql.org (Postfix) with ESMTP id DCD2D3A57AD for ; Mon, 24 Jan 2005 23:41:55 +0000 (GMT) X-EthosMedia-Virus-Scanned: no infections found Received: from [64.81.245.111] (account josh@agliodbs.com HELO temoku.sf.agliodbs.com) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.1.8) with ESMTP id 6946400; Mon, 24 Jan 2005 15:43:38 -0800 From: Josh Berkus Reply-To: josh@agliodbs.com Organization: Aglio Database Solutions To: Ragnar =?utf-8?q?Hafsta=C3=B0?= Subject: Re: PgPool changes WAS: PostgreSQL clustering VS MySQL Date: Mon, 24 Jan 2005 15:45:51 -0800 User-Agent: KMail/1.7.1 Cc: pgsql-performance@postgresql.org, Tatsuo Ishii References: <200501210947.53938.josh@agliodbs.com> <200501240952.40183.josh@agliodbs.com> <1106591045.22635.7.camel@localhost.localdomain> In-Reply-To: <1106591045.22635.7.camel@localhost.localdomain> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200501241545.51737.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.029 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200501/444 X-Sequence-Number: 10134 Ragnar, > note that these sometimes do not provide connection pooling as such, > just persistent connections (Apache::DBI) Yes, right. > no. you can only count on web-server-process==connection, but not > web-user==connection, unless you can garantee that the same user > client always connects to same web-server process. Are there ones that you use which might use several different connections to send a series of queries from a single web-user, less than 5 seconds apart? -- --Josh Josh Berkus Aglio Database Solutions San Francisco