Skip to content

Commit 64b99b3

Browse files
author
Marc Cousin
committed
Support reWriteBatchedInserts in PostgreSQL's jdbc driver
This is not supported by the JDBC driver provided with current (6.1 PDI). When it will be, though, it can almost double the per session throughput of inserts in PostgreSQL. This probably won't have any impact on most cases, but why not take advantage of this.
1 parent f6166e7 commit 64b99b3

1 file changed

Lines changed: 1 addition & 0 deletions

File tree

‎sqlserver2pgsql.pl‎

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -2727,6 +2727,7 @@ BEGIN
27272727
<data_tablespace/>
27282728
<index_tablespace/>
27292729
<attributes>
2730+
<attribute><code>EXTRA_OPTION_POSTGRESQL.reWriteBatchedInserts</code><attribute>true</attribute></attribute>
27302731
<attribute><code>FORCE_IDENTIFIERS_TO_LOWERCASE</code><attribute>N</attribute></attribute>
27312732
<attribute><code>FORCE_IDENTIFIERS_TO_UPPERCASE</code><attribute>N</attribute></attribute>
27322733
<attribute><code>IS_CLUSTERED</code><attribute>N</attribute></attribute>

0 commit comments

Comments
 (0)