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) within seconds, 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 the same 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 bad if a request for a page
was served by a db server that didn't yet have information about the user (such
as that they're logged in, etc.).
If we ever have enough traffic to warrant it, we're going to go to a
load balancer that passes requests to different identical web servers, at which
point we won't even be getting requests from the same machine, much less the
same connection.
Thanks,
Peter Darley
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] 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 [EMAIL PROTECTED])
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
