Re: [postgis-users] parallel-processing multiple similar query tasks - any example?

2022-04-28 Thread David Haynes
I think you need to provide more information as parallel queries in a
database can be done in many ways. You could look at CitusDB, which
supports PostGIS if you are trying to do parallel queries. PostgreSQL also
supports workers.
https://www.postgresql.org/docs/current/how-parallel-query-works.html

On Wed, Apr 27, 2022 at 6:33 PM 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?
>
> Regards,
>
> David
> ___
> postgis-users mailing list
> postgis-users@lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
___
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users


[postgis-users] parallel-processing multiple similar query tasks - any example?

2022-04-27 Thread Shaozhong SHI
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
___
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users