Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Congratulations to the new Qlik Luminary and Partner Ambassador class! Meet them here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2015-07-21 05:43 AM

Preformance using postgres

Hi,

I am using Postgres Db to load my data from one table to another.
Its a very simple ETL with source-map-destination.No complex logic.
The talend job is loading the data with 80rows/sec,so to load 600,000 records is taking more than 2 hrs.
Please suggest me to improve the performace of my ETL job. 

Labels (2)
Labels
330 Views
0 Likes
1 Reply
Anonymous
Not applicable
‎2015-07-22 12:11 AM
Author

Hi,

How did you set "Use Batch Size" option in Advanced Settings of tPostgreOutput component?
This option is used to activate the batch mode for data processing. When it is checked out, you can type in the number you need to define the batch size to be processed.

Best regards
Sabrina


0683p000009MGau.png
330 Views
0 Likes