Craig James <craig_james(at)emolecules(dot)com> wrote:
> I always just assumed that lots of backends that would be harmless
> if each one was doing very little.
Even if each is doing very little, if a large number of them happen
to make a request at the same time, you can have problems. This is
exactly where a connection pool can massively improve both
throughput and response time. If you can arrange it, you want a
connection pool which will put a limit on active database
transactions and queue requests to start a new transaction until one
of the pending ones finishes.
-Kevin