Josh,
Please excuse how my client quotes things...
> 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 client)
withinseconds, or even simultaneously, that use different connections.
When someone logs in to our system they get a frameset that has 5 windows, each of which is filled with data from
queries. Since the pages in the frames are requested separately by the client the system doesn't insure that they go to
thesame process, and subsequently, that they're not served by the same db connection.
Session information is stored in the database (so it's easily persistent across server processes), so it would be
badif a request for a page was served by a db server that didn't yet have information about the user (such as that
they'relogged in, etc.).
If we ever have enough traffic to warrant it, we're going to go to a load balancer that passes requests to
differentidentical web servers, at which point we won't even be getting requests from the same machine, much less the
sameconnection.
Thanks,
Peter Darley
-----Original Message-----
From: pgsql-performance-owner@postgresql.org
[mailto:pgsql-performance-owner@postgresql.org]On Behalf Of Josh Berkus
Sent: Monday, January 24, 2005 3:46 PM
To: Ragnar Hafstað
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 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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)