I am trying to insert over 1 million rows into a PostgreSQL table on RDS using the tDBOutputBulkExec but get an error that indicates that I need to be a superuser. Is there another option within Talend to do this? I tried the tDBOutput, but with the number of rows that I'm dealing with, it appears that it will run too long.
With tPostgresOutput in the advanced setting of the component, you can increase the batch size (avoid commit downtime) and enable parallel insertion.
Alternatively, if your organisation allows it. You could
Setting the batch size did the trick. I didn't see that option because it doesn't appear if you have your action on data set to 'Insert or Update' or 'Update or Insert'.