Hibernate multi row insert postgresql

Question

Now I have working batch inserts with hibernate ("hibernate.jdbc.batch_size = 50) but as far as i know hibernate generates single inserts in batches. I know that I can tell my db driver to create multi-row insert for every batch of inserts to speed up performance using rewriteBatchedStatements: jdbc:postgresql://localhost:5432/mydb?rewriteBatchedStatements=true

But in db logs there are still single inserts. What am I doing wrong? Thanks.

How do you generate primary keys?

sibnick
– sibnick

2015-08-20 15:09:39 +00:00
Commented Aug 20, 2015 at 15:09 — sibnick
– sibnick, Commented Aug 20, 2015 at 15:09

Community · Accepted Answer · 2017-05-23 10:29:23Z

4

This actually has nothing to do with Hibernate. The inserts are handled by the JDBC driver.

rewriteBatchedStatements is a MySQL specific parameter so it won't work with a PostgreSQL database. If you really need to do bulk inserts with PostgreSQL, take a look at this other answer which explains how to do it.

edited May 23, 2017 at 10:29

CommunityBot

11 silver badge

answered Aug 20, 2015 at 15:10

Tunaki

138k46 gold badges370 silver badges443 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Hibernate multi row insert postgresql

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related