This is an automated email from the ASF dual-hosted git repository. yiguolei pushed a commit to branch branch-2.0 in repository https://gitbox.apache.org/repos/asf/doris.git
commit 9ac55ffb21e00b1c1ade084628e75fe0fe4d927a Author: zy-kkk <[email protected]> AuthorDate: Mon Aug 21 23:46:27 2023 +0800 [improve](jdbc catalog) Improve the speed of writing to postgresql databases (#23279) reWriteBatchedInserts (boolean) Default false This will change batch inserts from insert into foo (col1, col2, col3) values (1, 2, 3) into insert into foo (col1, col2, col3) values (1, 2, 3), (4, 5, 6) this provides 2-3x performance improvement from https://jdbc.postgresql.org/documentation/use/#reWriteBatchedInserts delete useless parameters useCursorFetch --- fe/fe-core/src/main/java/org/apache/doris/catalog/JdbcResource.java | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/fe/fe-core/src/main/java/org/apache/doris/catalog/JdbcResource.java b/fe/fe-core/src/main/java/org/apache/doris/catalog/JdbcResource.java index 459e5a6ba8..dcf144b615 100644 --- a/fe/fe-core/src/main/java/org/apache/doris/catalog/JdbcResource.java +++ b/fe/fe-core/src/main/java/org/apache/doris/catalog/JdbcResource.java @@ -315,7 +315,7 @@ public class JdbcResource extends Resource { } } if (dbType.equals(POSTGRESQL)) { - newJdbcUrl = checkAndSetJdbcBoolParam(newJdbcUrl, "useCursorFetch", "false", "true"); + newJdbcUrl = checkAndSetJdbcBoolParam(newJdbcUrl, "reWriteBatchedInserts", "false", "true"); } if (dbType.equals(SQLSERVER)) { newJdbcUrl = checkAndSetJdbcBoolParam(newJdbcUrl, "useBulkCopyForBatchInsert", "false", "true"); --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
