From: Tatsuo Ishii <t-ishii@sra.co.jp>
To: gnari@simnet.is
Cc: josh@agliodbs.com
Cc: pgsql-performance@postgresql.org
Subject: Re: PgPool changes WAS: PostgreSQL clustering VS MySQL
Date: Tue, 25 Jan 2005 09:21:09 +0900 (JST)
Message-ID: <20050125.092109.71083385.t-ishii@sra.co.jp> (raw)
In-Reply-To: <1106591045.22635.7.camel@localhost.localdomain>
References: <20050124.103033.21930526.t-ishii@sra.co.jp>
<200501240952.40183.josh@agliodbs.com>
<1106591045.22635.7.camel@localhost.localdomain>
> On Mon, 2005-01-24 at 09:52 -0800, Josh Berkus wrote:
> > [about keeping connections open in web context]
> > Ah, clarity problem here. I'm talking about connection pooling tools from
> > the client (webserver) side, such as Apache::DBI, PHP's pg_pconnect,
> > Jakarta's connection pools, etc. Not pooling on the database server side,
> > which is what pgPool provides.
>
> note that these sometimes do not provide connection pooling as such,
> just persistent connections (Apache::DBI)
Right. Same thing can be said to pg_pconnect.
> > Most of these tools allocate a database connection to an HTTP/middleware
> > client, and only release it after a specific period of inactivity. This
> > means that you *could* count on "web-user==connection" for purposes of
> > switching back and forth to the master -- as long as the connection-recycling
> > timeout were set higher than the pgPool switch-off period.
>
> 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.
I have same opinion.
> am i missing something ?
--
Tatsuo Ishii
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: t-ishii@sra.co.jp, gnari@simnet.is, josh@agliodbs.com
Subject: Re: PgPool changes WAS: PostgreSQL clustering VS MySQL
In-Reply-To: <20050125.092109.71083385.t-ishii@sra.co.jp>
References: <20050124.103033.21930526.t-ishii@sra.co.jp> <200501240952.40183.josh@agliodbs.com> <1106591045.22635.7.camel@localhost.localdomain> <20050125.092109.71083385.t-ishii@sra.co.jp>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox