community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!

Bulk Loader Capability for Postgres SQL

Hi,

 

     Currently loading large files to Postgres SQL(over 100 MB) takes an extremely long time. For example writing a 1GB file to Postgres SQL takes 27 minutes! This is serious impacting our ability to use Alteryx as an ETL tool for loading our target Postgres Data Warehouse. We would really like to see the bulk load capacity to Postgres supported by Alteryx to help alleviate the performance issues.

 

Thanks,

Vijaya

30 Comments
Asteroid

Desperately need this!!!!

We also really need this functionnality.

Atom

Any movement on this? My company will not be renewing licenses if this bug is not fixed as we are migrating to a PostGres platform.

Alteryx
Alteryx

We are going to speed up the PostgreSQL inserts, hopefully already in 19.3. We also have the bulk updates (in general) in the plans for the second half of 2019 and PostgreSQL is one of the top candidates on our list.

Fantastic news Bora! 

Bora, regarding speeding up the inserts, is this via standard output tools as well as write in-db? I see huge value in both angles. 

Asteroid

Hi,

 

Is there a timeline update on this?  knowing the timeline will help us decide our way forward

Alteryx
Alteryx

I cannot unfortunately yet commit to any timelines here, we are constantly revising the resourcing. It is among the top 10 of the connectors activities.

Regarding In-DB (Stream In/Out): we will see about the batching (multi value inserts); bulk loaders are more difficult here and while we are planning it this is more a longer term

Atom

To elaborate on my previous comment, decision time for renewing is coming in early September. If we do not see this issue remedied by end of August, we will not renew our licenses. 

 

Please use the statement above in your internal meetings regarding resourcing to focus on this issue so that you can keep a customer who would like to stay a customer and actually wants to expand the number of licenses purchased, but can't due to this issue.

 

Might be too late for us by then, but at least wanted to provide a public comment  you can refer to that this issue is important to some of your customers, and that you will lose revenue as a result of not being fixed.

Good day!

 

Is there an update for Bulk Data Loader for Postgres SQL?

 

Also, see comments related to Bulk loader for GreenPlum being "cancelled".  

 

Is Greenplum on the roadmap for Bulk Loader?

 

Thank you!