Clever Geek Handbook

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?

+3


source to share


2 answers


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



+3


source


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.

0


source






More articles:


All Articles