MIME-Version: 1.0
References: 
 <CA+i5JwaC9Z-rjWiyo7LpncdK=CuQcKzuVNMnAhPW1oi=8c9Sug@mail.gmail.com>
In-Reply-To: 
 <CA+i5JwaC9Z-rjWiyo7LpncdK=CuQcKzuVNMnAhPW1oi=8c9Sug@mail.gmail.com>
From: Shaozhong SHI <shishaozhong@gmail.com>
Date: Thu, 28 Apr 2022 00:33:49 +0100
Message-ID: 
 <CA+i5JwZ1_gu0g-X+5P8hVhyc1YS7F4nhrcEQdZKADOp+7o+1SQ@mail.gmail.com>
Subject: parallel-processing multiple similar query tasks - any example?
To: pgsql-sql <pgsql-sql@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000073f9d405ddab3eb3"
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2Bi5JwZ1_gu0g-X%2B5P8hVhyc1YS7F4nhrcEQdZKADOp%2B7o%2B1SQ%40mail.gmail.com>
Precedence: bulk

--00000000000073f9d405ddab3eb3
Content-Type: text/plain; charset="UTF-8"

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?

Regards,

David

--00000000000073f9d405ddab3eb3
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail=
_attr"><br></div><br><br><div dir=3D"ltr">multiple similar query tasks are =
as follows:<div><br></div><div>select * from a_table where country =3D&#39;=
UK&#39;</div><div>select * from a_table where country=3D&#39;France&#39;</d=
iv><div>and so on</div><div><br></div><div>How best to parallel-processing =
such types of multiple similar query tasks?</div><div><br></div><div>Any ex=
ample available?</div><div><br></div><div>Regards,</div><div><br></div><div=
>David</div></div>
</div></div>

--00000000000073f9d405ddab3eb3--