This is an automated email from the ASF dual-hosted git repository.
zykkk pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push:
new ae48de70d6 [improve](jdbc catalog) Improve the speed of writing to
postgresql databases (#23279)
ae48de70d6 is described below
commit ae48de70d6e040186c817a99320fbc7226631a9c
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]
