Writing to PostgreSQL

More
3 days 6 hours ago - 3 days 6 hours ago #26307 by Derrick
Hi. 

We are writing 33k records to PostgreSql table..

It currently is taking 9 minutes to write those 27k records. 
The vendor is seeing it as single commit. 

Is there a way to "push" in a single batch?
Last edit: 3 days 6 hours ago by Derrick.

Please Log in or Create an account to join the conversation.

More
2 days 8 hours ago - 2 days 8 hours ago #26308 by admin
Replied by admin on topic Writing to PostgreSQL
I not sure I understand your question

We use third party components for loading data into PostgreSQL.

It uses COPY command internally
www.postgresql.org/docs/current/sql-copy.html

As far as I am aware it is the fastest way to load the data.I have never heard about single batch...

Mike
ETL Architect
Last edit: 2 days 8 hours ago by admin.
The following user(s) said Thank You: Derrick

Please Log in or Create an account to join the conversation.

More
7 hours 53 minutes ago #26309 by Derrick
Replied by Derrick on topic Writing to PostgreSQL
Good Morning.

You use a "copy" command to do an Add All records from a sql query string as the source?

Is there a setting to do a commit at the end instead of each record?

Please Log in or Create an account to join the conversation.

Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Read more
Marketing
Set of techniques which have for object the commercial strategy and in particular the market study.
Google
Accept
Decline
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline
Google Analytics
Accept
Decline
Functional
Tools used to give you more features when navigating on the website, this can include social sharing.
Advertisement
If you accept, the ads on the page will be adapted to your preferences.
Google Ad
Accept
Decline
Save