No, No.
Why sleep(1)?
It should be all active - doing work concurrently.
Regards,
David
On Thu, 28 Apr 2022 at 16:17, Alvaro Herrera <alvherre@xxxxxxxxxxxxxx> wrote:
On 2022-Apr-28, Shaozhong SHI 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?
for country in UK France Germany Ireland; do
echo "select pg_sleep(1); select * from a_table where country = '${country//\'/''/}'"
done | \
xargs -d"\n" -P10 -n1 psql -X -c
Note the ${country/} stuff is a bash-ism.
--
Álvaro Herrera
