[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] parallel-processing multiple similar query tasks - any example?
From:       David Haynes <haynesd2 () gmail ! com>
Date:       2022-04-29 3:20:09
Message-ID: CAM4C04pn3o0Spv6qwugubE8OzY03awMDhLxZecrSYy1gcuyaAQ () mail ! gmail ! com
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]


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 <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?
>
> Regards,
>
> David
> _______________________________________________
> postgis-users mailing list
> postgis-users@lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>

[Attachment #5 (text/html)]

<div dir="ltr">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. <a \
href="https://www.postgresql.org/docs/current/how-parallel-query-works.html">https://www.postgresql.org/docs/current/how-parallel-query-works.html</a></div><br><div \
class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Apr 27, 2022 at 6:33 PM \
Shaozhong SHI &lt;<a \
href="mailto:shishaozhong@gmail.com">shishaozhong@gmail.com</a>&gt; \
wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div \
dir="ltr">multiple similar query tasks are as follows:<div><br></div><div>select * \
from a_table where country =&#39;UK&#39;</div><div>select * from a_table where \
country=&#39;France&#39;</div><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 example \
available?</div><div><br></div><div>Regards,</div><div><br></div><div>David</div></div>
 _______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" \
target="_blank">postgis-users@lists.osgeo.org</a><br> <a \
href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" \
target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><br> \
</blockquote></div>



_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users


[prev in list] [next in list] [prev in thread] [next in thread]