I have created a delta load using Talend.
Everything is working fine except updating the columns seems to take forever.
In tPostresqlOutput I am using 'Update' in Action on data.
The table to be updated has more than 7 million rows but I am updating only 500 rows but still it is taking too much time.
Is there a way to fix this issue?
I might be updating even bigger tables later so this is a big problem for me.
How can I delete this post?
Last edited by jfaza (2017-01-20 16:16:23)
Could you please give us more information about your issue? Is there any error message when you check out option "die on error" on tPostgresqlOutput component?
What we can do is to make sure that Talend will be your best choice!