Postgres Pro
Downloads
Home   >   mailing lists

Re: parallel-processing multiple similar query tasks - any example? - Mailing list pgsql-general

From David G. Johnston
Subject Re: parallel-processing multiple similar query tasks - any example?
Date
Msg-id CAKFQuwaSd+7CnFgsVRW0GwXCTraGBMZYk5hmoJXtE98XUfBF4g@mail.gmail.com
Whole thread Raw
In response to Re: parallel-processing multiple similar query tasks - any example?  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view
On Wed, Apr 27, 2022 at 4:44 PM David G. Johnston <david.g.johnston@gmail.com> wrote:
On Wed, Apr 27, 2022 at 4:34 PM Shaozhong SHI <shishaozhong@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.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Backing up a DB excluding certain tables
Next
From: "Dives, Chloe"
Date:
Subject: RE: Privilege error with c functions during postgresql upgrade from 11 -> 13