Postgres Insert Performance

Postgres Insert Performance

Postby sxwalsh55 » Fri 16 Sep 2016 20:55

Any thoughts or guidance on trouble shooting performance on these components? I've had a set that were running fairly well but recently the performance has dropped significantly and I'm quite sure what to check.

I'm using the postgres destination, uploading to a heroku based instance.


Thanks in advance
sxwalsh55
 
Posts: 4
Joined: Tue 26 Jul 2016 01:50

Re: Postgres Insert Performance

Postby Shalex » Fri 07 Oct 2016 20:14

Sorry for the delay.

Is the problem solved? If not, refer to documentation (download, right click > Properties > Unblock) > Custom Properties Reference > Devart PostgreSQL Destination and make sure that you are using BulkInsertMode=Binary and Operation=BulkInsert.

Does this help?
Shalex
Devart Team
 
Posts: 7781
Joined: Thu 14 Aug 2008 12:44


Return to SSIS Data Flow Components