Kirk Strauser <kirk@xxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general