Sign up to save your podcasts
Or
Share Postgres Performance Optimization: Connection Pooling, JDBC, and Distributed Databases
Share to email
Share to Facebook
Share to X
Share to email
Share to Facebook
Share to X
Or
Postgres Performance Optimization: Connection Pooling, JDBC, and Distributed Databases
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
View all episodes
By Adam Bien
5
55 ratings
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
More shows like airhacks.fm podcast with adam bien
View all
Software Engineering Radio - the podcast for professional software developers
272 Listeners
The Changelog: Software Development, Open Source
284 Listeners
Thoughtworks Technology Podcast
40 Listeners
Software Engineering Daily
621 Listeners
Soft Skills Engineering
269 Listeners
AWS Podcast
201 Listeners
Duke's Corner
8 Listeners
Syntax - Tasty Web Development Treats
987 Listeners
CoRecursive: Coding Stories
189 Listeners
A Bootiful Podcast
29 Listeners
The Stack Overflow Podcast
62 Listeners
Mac & i - der Apple-Podcast
0 Listeners
Inside Java
26 Listeners
Foojay.io, the Friends Of OpenJDK!
0 Listeners
The Pragmatic Engineer
53 Listeners