Page 1 of 1

Postgres Insert Performance

Posted: Fri 16 Sep 2016 20:55
by sxwalsh55
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

Re: Postgres Insert Performance

Posted: Fri 07 Oct 2016 20:14
by Shalex
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?