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