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 CAKFQuwZx2Rj8n0k1LZq72fpdg1t6W+z_okFU2t5D8ftzTUdLMA@mail.gmail.com
Whole thread Raw
In response to parallel-processing multiple similar query tasks - any example?  (Shaozhong SHI <shishaozhong@gmail.com>)
Responses 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: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.

David J.

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Backing up a DB excluding certain tables
Next
From: Adrian Klaver
Date:
Subject: Re: Backing up a DB excluding certain tables