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?

Dmitry Negoda · Accepted Answer · 2012-03-09 19:12:55Z

6

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

answered Mar 9, 2012 at 19:12

Dmitry Negoda

3,2012 gold badges20 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

mleko Over a year ago

you mean they're gonna be serialized in the same connection?

Community · Accepted Answer · 2017-05-23 12:31:26Z

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, 2017 at 12:31

CommunityBot

11 silver badge

answered Mar 29, 2016 at 2:49

Robins Tharakan

2,52122 silver badges19 bronze badges

Comments

PostgresSucks · Accepted Answer · 2023-05-02 12:46:26Z

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 2, 2023 at 12:46

PostgresSucks

1

Collectives™ on Stack Overflow

Does PostgreSQL allow running stored procedures in parallel?

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related