Struggling to update/insert 100000 records into postgresql in under 20 seconds
Summary The issue at hand is optimizing batch updates in a PostgreSQL database using Spring Boot. The current implementation using jdbcTemplate.batchUpdate takes around 2 minutes to update 100,000 records, which is unacceptably slow. The goal is to achieve batch updates in under 15 seconds. Root Cause The root cause of this issue is likely due … Read more