Take a Dip in the Pooler

I recently mentioned the use of connection poolers to reduce the
overhead of server-side language initialization, but I believe the topic warrants fuller coverage.

Aside from the ability to reduce language initialization overhead, the two major advantages of connection pooling are:

  • Reducing session startup time by preallocating and reusing database sessions
  • Reducing session management overhead by reducing the number of idle sessions

Continue Reading »