Connection Pooling 101
Time: 14:30 - 15:20
Pooling, particularly with java and pgbouncer is one of the most common things dealt with - and very easy to get wrong. This session will be an in depth look at the types, cost, benefits and drawbacks. Frameworks such as spring and hibernate often force applications into certain pooling choices with little to no information on how that effects the underlying database, and what can be done about it. PgBouncer also makes sacrifices based on functionality for performance. Postgres itself has no built in pooling, but does have a high cost to scale connections. So how do you find that balance? How do you implement it? What tools can be used, or do not yet exist to make this happen?