Performance of simple select query from 4.3.10.Final to 5.4.2.Final

Description

There is a huge performance difference between the 4.3.10 & 5.4.2. 6.0.0.Alpha4 seems to be performing well, but the fix needs to be backported to 5 also

Please run the attached class BatchMain. Configure PostgreSQL connection details as appropriate.

 

Test code

https://github.com/ramanans/hibernate-perf-test/tree/master/08_batch

 

With other versions

4.3.10 ===== time taken for insert===== 22274 ms select took : 36388 ms ===== total time taken ===== 58954 ms

5.4.2 ===== time taken for insert===== 22592 ms select took : 41843 ms ===== total time taken ===== 65648 ms

5.4.10==== time taken for insert===== 22395 ms select took : 41416 ms ===== total time taken ===== 64656 ms

6.0.0.Alpha4 === time for insert===== 23555 ms select took : 34776 ms ===== total time taken ===== 59127 ms

 

Environment

Windows, Java 11, Postgresql 9.6

Assignee

Unassigned

Reporter

Venkatramanan Swaminathan

Fix versions

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Worked in

4.3.10

Components

Affects versions

Priority

Critical
Configure