Want to create an interactive transcript for this episode?
Podcast: airhacks.fm podcast with adam bien
Episode: Postgres Performance Optimization: Connection Pooling, JDBC, and Distributed Databases
Description: An airhacks.fm conversation with Alvaro Hernandez (@ahachete) about:
discussion on Postgres JDBC driver contributions,
SCRAM authentication library implementation,
importance of connection pooling for Postgres performance,
tuning Postgres configuration,
PgBouncer as a popular connection pooler,
challenges with lambda and database connections,
benefits of using connection poolers at multiple levels,
the need for an HTTP-based protocol for PostgreSQL,
PostgresSQL Configuration Tool by StackGres,
distributed SQL databases like DSQL and their trade-offs,
optimistic vs pessimistic locking in distributed databases,
comparison of JPA optimistic locking to distributed database conflicts,
the power of using SQL directly vs ORM frameworks,
the evolution of Java and...