Re: [postgis-users] How does PostGIS / PostgreSQL distribute parallel work to cores for GIS type data?

2020-03-01 Thread Komяpa
Hi, There are different ways to push down complexity of each record. Most popular ones are simplification and subdivision. For polygons, you can create a new table which will have all polygons split into small pieces with limited amount of vertices using ST_Subdivide. This way instead of more of O

Re: [postgis-users] How does PostGIS / PostgreSQL distribute parallel work to cores for GIS type data?

2020-03-01 Thread Marco Boeringa
Hi Darafei, Sorry, but I do not have the intimate knowledge of the intricacies of PostgreSQL / PostGIS that you have, so my post was more of the layman's level regarding the database itself. My main expertise is more in the field of GIS. Anyway, regarding your post, I think this already answ

Re: [postgis-users] How does PostGIS / PostgreSQL distribute parallel work to cores for GIS type data?

2020-03-01 Thread Komяpa
Hi, Can you please be more specific with the question? Parallelism is tuple level. All load balancing is provided by Postgres - different Parallel Scan types have different ordering properties and different tuple passing graph. Parallel index scan pushes out each tuple to next free worker, essent