[postgis-devel] [PostGIS] #2051: ST_AsGeoJSON printing too many digits

PostGIS trac at osgeo.org
Wed Oct 17 04:54:50 PDT 2012

#2051: ST_AsGeoJSON printing too many digits
 Reporter:  strk     |       Owner:  pramsey      
     Type:  defect   |      Status:  new          
 Priority:  medium   |   Milestone:  PostGIS 2.0.2
Component:  postgis  |     Version:  2.0.x        
 Keywords:           |  

Comment(by strk):

 A rude profiling tool:

 time psql -xAtc "select sum(octet_length(st_asgeojson(g))) from ( select
 st_makepoint(random(), random()) as g from generate_series(1,10000000) )
 as f;"

 Takes 28.92 seconds for me on trunk and 28.64 on 2.0.
 Doesn't look like any dramatic slowdown, does it ?

Ticket URL: <http://trac.osgeo.org/postgis/ticket/2051#comment:14>
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-devel mailing list