[PostgreSQL] Execute SQL script statements in parallel

tarancepil7's profile image tarancepil7 posted 4 years ago in Running SQL scripts Permalink

Hello,

I am trying to work on a very large database. I am using an SQL script with a series of Insert statements via Select. So, all the insert statements with the select, select from the same table and insert the results into a different table. Is there a way, that I can run these statements in a script in parallel. I have a server with 20 cores and I would like to run these statements inside the script in parallel. I dont want to do this manually i.e. running every statement from command line.

Please login to leave a reply, or register at first.