Re: Why would I want to use connection pooling middleware?

Kirk Strauser <kirk@strauser.com> wrote:

[snip]

> I understand why pooling within a process itself is a good thing.
> However, say I have two users running the same program on different
> desktop machines.  At present, those applications connect with the
> same username/password that's tied to the program and not the actual
> user.  It seems like if Abby and Barb end up sharing the same
> connection from the pool, and Abby runs some giant report query, then
> Barb would get held back while she waits for it to finish.  Is that
> true?

I don't believe that's true.  My understanding of pgpool is that it will
reuse an existing connection if it's free, or open a new one if required.

--
Bill Moran
http://www.potentialtech.com