How best to do parallel query given tens of thousands of iteration of a loop of recursive queries?

Shaozhong SHI <shishaozhong@gmail.com>

From: Shaozhong SHI <shishaozhong@gmail.com>
To: pgsql-sql <pgsql-sql@lists.postgresql.org>
Date: 2022-04-10T13:50:32Z
Lists: pgsql-sql
There is a plpgsql script that have a loop to carry out the same recursive
queries.

The estimation of iteration is in the order of tens of thousands.

What is the best way of making using parallel query strategy.

Any examples?

Regards,

David