On Wed, Apr 27, 2022 at 4:44 PM David G. Johnston < david.g.johns...@gmail.com> wrote:
> On Wed, Apr 27, 2022 at 4:34 PM Shaozhong SHI <shishaozh...@gmail.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.
