Re: parallel-processing multiple similar query tasks - any example?

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Wed, Apr 27, 2022 at 4:44 PM David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:

On Wed, Apr 27, 2022 at 4:34 PM Shaozhong SHI <shishaozhong@xxxxxxxxx> wrote:

multiple similar query tasks are as follows:

select * from a_table where country ='UK'

select * from a_table where country='France'

and so on

How best to parallel-processing such types of multiple similar query tasks?

Any example available?

You should search for how to run processes/commands in parallel in whatever client-side execution environment you want to use.  There isn't anything specific to PostgreSQL here.

You should also read:

https://www.postgresql.org/docs/current/parallel-query.html

If you want to see when a single query can be executed using parallel workers.

David J.