Postgres for Java Developers

on YouTube ↗44m

" summary

Migration of a high-load service from Oracle to PostgreSQL and practical Java-side adjustments needed for that move. Covers concrete configuration tips for the pgJDBC driver, Hikari connection pool, and Spring — a collection of settings that solved performance and operational issues encountered during the migration. Does not cover Hibernate.

AI-written summary · about

" chapters (12)

1. 0:00Introduction
2. 2:27HikariCP driver setup
3. 8:33Connection timeouts
4. 13:53Connecting to replicas
5. 16:05Monitoring connections
6. 19:57Application name for queries
7. 22:45Min Server Version for speed
8. 23:07Batch inserts
9. 29:57Null parameter issues
10. 33:50Optimizing via Get param Type
11. 38:45Final config file
12. 40:35Q&A

" related talks

• 52mPostgreSQL and Java: Best PracticesÁlvaro Hernández · PostgresOpen 2014
• 14mPlanetary Scale Postgres for Spring Boot Apps: A Fast Migration Path for DevsMark Heckler · Azure Cosmos DB: Liftoff 2022
• 06mMigration Consideration Oracle to PostgreSQLNeeta Goel · PGConf India 2025
• 48mMigrating to PostgreSQL: Strategies, Sovereignty, and SuccessRaphael Salguero · PostgreSQL Conference Europe 2025
• 46mThe Top 10 Mistakes When Migrating Oracle Databases to PostgreSQLJim Mlodgenski · Percona Live 2022
• 29mTales from the Field - Oracle to PostgreSQL migrationsAdithya Kumaranchath · POSETTE: An Event for Postgres 2024
• 01h 05mHigh-Performance JDBCVlad Mihalcea · Voxxed Days Bucharest 2016
• 43mPostgresQL as an Application ModernizationCharles Finley · PGConf Silicon Valley 2016