[postgis-tickets] [PostGIS] #2933: Speed up ST_GeomFromWKB

PostGIS trac at osgeo.org
Fri Sep 19 08:24:25 PDT 2014


#2933: Speed up ST_GeomFromWKB
-------------------------+--------------------------------------------------
 Reporter:  strk         |       Owner:  pramsey
     Type:  enhancement  |      Status:  new    
 Priority:  medium       |   Milestone:         
Component:  postgis      |     Version:  trunk  
 Keywords:               |  
-------------------------+--------------------------------------------------

Comment(by pramsey):

 Well, given that the linestring is "faster" my guess would be that if you
 put it in a profiler you'll see a lot of time spend in allocations, since
 the multipolygon is going to have lots of pointarray and lwgeom objects
 getting instantiated to hold the bits and pieces of your complex input.
 The linestring is far more pure, since it just needs to allocate the point
 storage buffer once and then just a few more reallocations as it doubles
 it each time it overflows. I should be able to duplicate your result by
 testing a multilinestring, will check.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2933#comment:7>
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