[postgis-tickets] [PostGIS] #3587: lwgeom_mindistance2d slows down topology loading
PostGIS
trac at osgeo.org
Mon Jul 4 17:59:52 PDT 2016
#3587: lwgeom_mindistance2d slows down topology loading
-----------------------+---------------------------
Reporter: strk | Owner: strk
Type: defect | Status: new
Priority: medium | Milestone: PostGIS 2.2.3
Component: topology | Version: 2.2.x
Resolution: | Keywords: performance
-----------------------+---------------------------
Comment (by strk):
An STRtree node capacity of 256 resulted in raising the timings to ~5
seconds.
A node capacity of 32 made timings =~ 2 seconds.
A node capacity of 4 made timings =~ 686 ms.
A node capacity of 2 made timings =~ 532 ms.
A node capacity of 1 resulted in a segfault.
I'm not sure what to make of these numbers.
--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3587#comment:30>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.
More information about the postgis-tickets
mailing list