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 Aug 20 '15 at 15:09 — sibnick, Aug 20 '15 at 15:09

score 3 · Answer 1 · edited May 23 '17 at 10:29

3

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 '17 at 10:29

Community

1
1

answered Aug 20 '15 at 15:10

Tunaki

116,530
39
281
370

Hibernate multi row insert postgresql

1 Answers1

Linked