Does PostgreSQL allow running stored procedures in parallel?

Question

I'm working with an ETL tool, Business Objects Data Services, which has the capability of specifying parallel execution of functions. The documentation says that before you can do this, you have to make sure that your database, which in our case is Postgres, allows "a stored procedure to run in parallel". Can anyone tell me if Postgres does that?

score 5 · Accepted Answer · answered Mar 09 '12 at 19:12

5

Sure. Just run your queries in different connections, and they will run in parallel transactions. Beware of locking though.

answered Mar 09 '12 at 19:12

Dmitry Negoda

2,894
2
18
15

you mean they're gonna be serialized in the same connection? – mleko Dec 19 '22 at 13:41

score 0 · Answer 2 · edited May 23 '17 at 12:31

0

You can also call different stored procedures from the same connection (and effectively still run them in parallel) by using DBLink.

See this SO answer to see an example.

edited May 23 '17 at 12:31

Community

1
1

answered Mar 29 '16 at 02:49

Robins Tharakan

2,209
19
17

score 0 · Answer 3 · answered May 02 '23 at 12:46

0

Use pgcron to schedule the procedure as many times you want. Use arguments to make the procedure act on different sets of data.

answered May 02 '23 at 12:46

PostgresSucks

1

Does PostgreSQL allow running stored procedures in parallel?

3 Answers3