Does PostgreSQL provide the ability to run stored procedures in parallel?

I am working with an ETL tool, Business Objects Data Services, which has the ability to specify parallel execution of functions. The documentation says that before you can do this, you must ensure that your database, which in our case is Postgres, allows a "stored procedure to run in parallel". Can anyone tell me that Postgres does this?


source to share

2 answers

Sure. Just run your queries on different connections and they will execute in parallel transactions. Beware of blocking.



You can also call different stored procedures from same connection

(and efficiently execute them in parallel) using DBLink .

See this one to answer this example.



All Articles