Handle big polygon faster
To convert this simple feature data test_10_b.sql.gz takes 'used_time: 474.1716'
There are one very big feature as you see
SELECT id, ST_NPoints(geo) num_points, ST_area(geo) sum_area_m2 FROM test_10.gsk_2023_test_segmenter_renska ORDER BY ST_NPoints(geo) desc;
id | num_points | sum_area_m2
---------+------------+-------------
4692268 | 333463 | 1490314
4783603 | 1911 | 77849
4684105 | 904 | 14923
5050113 | 679 | 11742
4628836 | 414 | 5337
5050109 | 361 | 825
4628854 | 155 | 407
I create a topology with 4258 with zero tolerance and I use SELECT topology.TopoGeo_addLinestring
I do not get any exceptions