[
https://issues.apache.org/jira/browse/HIVE-23032?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17067634#comment-17067634
]
Denys Kuzmenko edited comment on HIVE-23032 at 3/26/20, 3:36 PM:
-----------------------------------------------------------------
||Mode|partCount|tblCount|Cnt|Score|Error|Units||
|original|30|4|100|||ms/op|
|patched|30|4|100|261.323|± 4.767|ms/op|
|original|300|4|100|||ms/op|
|patched|300|4|100|338.376|± 3.474|ms/op|
|original|600|4|100|||ms/op|
|patched|600|4|100|515.727|± 12.683|ms/op|
|original|1200|4|100|||ms/op|
|patched|1200|4|100|752.484|±19.530|ms/op|
Oracle
||Mode|partCount|tblCount|Cnt|Score|Error|Units||
|original|30|4|100|||ms/op|
|patched|30|4|100|434.803|± 38.732|ms/op|
|original|300|4|100|||ms/op|
|patched|300|4|100|870.643|± 32.118|ms/op|
|original|600|4|100|||ms/op|
|patched|600|4|100|1443.972|± 110.546|ms/op|
|original|1200|4|100|||ms/op|
|patched|1200|4|100|2499.806|± 100.270|ms/op|
Postgres
||Mode|partCount|tblCount|Cnt|Score|Error|Units||
|original|30|4|100|||ms/op|
|patched|30|4|100|281.426|± 2.209|ms/op|
|original|300|4|100|||ms/op|
|patched|300|4|100|320.018|± 6.612|ms/op|
|original|600|4|100|||ms/op|
|patched|600|4|100|445.005|± 22.069|ms/op|
|original|1200|4|100|||ms/op|
|patched|1200|4|100|662.381|± 16.256|ms/op|
was (Author: dkuzmenko):
||Mode|partCount|tblCount|Cnt|Score|Error|Units||
|patched|30|4|100|261.323|± 4.767|ms/op|
|patched|300|4|100|338.376|± 3.474|ms/op|
|patched|600|4|100|515.727|± 12.683|ms/op|
|patched|1200|4|100|752.484|±19.530|ms/op|
Oracle
||Mode|partCount|tblCount|Cnt|Score|Error|Units||
|patched|30|4|100|434.803|± 38.732|ms/op|
|patched|300|4|100|870.643|± 32.118|ms/op|
|patched|600|4|100|1443.972|± 110.546|ms/op|
|patched|1200|4|100|2499.806|± 100.270|ms/op|
Postgres
||Mode|partCount|tblCount|Cnt|Score|Error|Units||
|patched|30|4|100|281.426|± 2.209|ms/op|
|patched|300|4|100|320.018|± 6.612|ms/op|
|patched|600|4|100|445.005|± 22.069|ms/op|
|patched|1200|4|100|662.381|± 16.256|ms/op|
> Add batching in Lock generation
> -------------------------------
>
> Key: HIVE-23032
> URL: https://issues.apache.org/jira/browse/HIVE-23032
> Project: Hive
> Issue Type: Improvement
> Components: Locking
> Reporter: Denys Kuzmenko
> Assignee: Denys Kuzmenko
> Priority: Major
> Attachments: HIVE-23032.1.patch, HIVE-23032.2.patch,
> HIVE-23032.3.patch, HIVE-23032.4.patch, HIVE-23032.5.patch,
> HIVE-23032.6.patch, HIVE-23032.7.patch
>
>
> Replace multi-row insert in Oracle with batching. Performance tests showed
> significant performance improvement after turning batching on.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
