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

On Wed, Apr 27, 2022 at 4:44 PM David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

> On Wed, Apr 27, 2022 at 4:34 PM Shaozhong SHI <shishaozhong(at)gmail(dot)com>
> 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.