[postgis-users] Need help to create an help table

[Tomas Straupis]

2021-01-30, št, 14:21 Luca Bertoncello rašė:
> Specially the first seems to need a huge amount of RAM and a fast CPU...
> Some polygon are very complex...

  If a polygon is too complex (which means it has too many vertexes),
then you have several directions of actions:
  1. Reduce the number of vertexes in a polygon (say use st_simplify,
st_snaptogrid or other functions which reduce number of vertexes)
  2. Split the initial polygon (thus making more polygons but with
fewer vertexes), process the parts and then reassemble the polygon.
  3. Split the process into parts. Process "smaller" aggregation say
with distance of 10m and simplification of 10m. Then repeat the same
steps on the result with larger aggregation of say 40m, then with 160m
etc.

  You can also debug the geometries you get (by looking at them in
QGIS) to check if parameters of the steps leading to buffer+- are ok
and you are buffering the correct geometries.

-- 
Tomas