/
PostgreSQL
PostgreSQL
Performance considerations
As reported in PDI-15692 there is a new option since PostgreSQL 9.4 that can speed up performance.
To get this working, you need to replace the jar driver by at least version 9.4 and add reWriteBatchedInserts to true in the PostgreSQL's connection parameters.
Note: This is not a tested nor fully supported configuration.
, multiple selections available,
Related content
.03 Database Connections
.03 Database Connections
Read with this
PA_CR_PA-3.9.X_presto-0.100
PA_CR_PA-3.9.X_presto-0.100
More like this
Pentaho Data Integration (aka Kettle) Concepts, Best Practices and Solutions
Pentaho Data Integration (aka Kettle) Concepts, Best Practices and Solutions
Read with this
PDI Performance tuning check-list
PDI Performance tuning check-list
More like this
Special database issues and experiences
Special database issues and experiences
Read with this
PostgreSQL Bulk Loader
PostgreSQL Bulk Loader
More like this