In Trino, a configurable Multi-row insert (multirow_batch_size parameter) to improve performance

[RaulRoPer]

Feature Description

In Trino, you can perform a multi-row insert to improve performance by batching up a series of inserts. This is particularly useful when adding multiple rows at once, as it enhances data compression and overall efficiency compared to inserting rows one by one or in small batches.

Given the low performance in data insertion in trinodb, it is presented as a necessary option for the tool.

[RaulRoPer]

Multi values insert : https://trino.io/docs/current/sql/values.html Issue exposition and conclusion: https://github.com/trinodb/trino/issues/5913