> Peter, Ragnar,
>
> > > 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?
> >
> > Using Apache/Perl I often have a situation where we're sending several
> > queries from the same
Peter, Ragnar,
> > 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?
>
> Using Apache/Perl I often have a situation where we're sending several
> queries from the same user (web cli
Ã
Cc: pgsql-performance@postgresql.org; Tatsuo Ishii
Subject: Re: [PERFORM] PgPool changes WAS: PostgreSQL clustering VS
MySQL
Ragnar,
> note that these sometimes do not provide connection pooling as such,
> just persistent connections (Apache::DBI)
Yes, right.
> no. you can only coun
On Mon, 2005-01-24 at 15:45 -0800, Josh Berkus wrote:
> [about keeping open DB connections between web-client connections]
> [I wrote:]
> > 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 conn
> 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
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 t
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 po
Tatsuo,
> > Depends on your connection pooling software, I suppose. Most connection
> > pooling software only returns connections to the pool after a user has
> > been inactive for some period ... generally more than 3 seconds. So
> > connection continuity could be trusted.
>
> Not sure what you