Skip to content
Postgres Performance Optimization: Connection Pooling, JDBC, and Distributed Databases episode artwork

Feb 2, 2025 1 hr 9 min

Postgres Performance Optimization: Connection Pooling, JDBC, and Distributed Databases

from airhacks.fm podcast with adam bien Hosted by adam-bien.com

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 JDBC making direct database queries more convenient, the potential benefits of using stored procedures in databases, the importance of understanding database internals for optimal performance, the need for careful consideration when choosing between ORM and direct SQL queries, the complexities of distributed databases and their impact on application design Alvaro Hernandez on twitter: @ahachete

Episode details come from the podcast's RSS feed.

Embed this episode

Ready to play

Postgres Performance Optimization: Connection Pooling, JDBC, and Distributed Databases

0:00 1:09:52

No transcript yet.

Requests help us decide what to transcribe next.

Frequently asked questions

How long is this episode of airhacks.fm podcast with adam bien?

This episode is 1 hour and 9 minutes long.

When was this airhacks.fm podcast with adam bien episode published?

This episode was published on February 2, 2025.

Can I download this airhacks.fm podcast with adam bien episode?

Yes. Use the download control on the episode player to save the publisher-provided media file.