Postgres Insert Performance

Discussion of issues, suggestions and bugs of Devart SSIS Data Flow Components, our product line for building SSIS-based ETL solutions, performing data access to popular cloud applications and databases.
Post Reply
sxwalsh55
Posts: 4
Joined: Tue 26 Jul 2016 01:50

Postgres Insert Performance

Post by 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
Top
Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Postgres Insert Performance

Post by 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?
Top
Post Reply

Return to “SSIS Data Flow Components”