[postgis-tickets] [PostGIS] #4372: PROJ 6: 4x slowdown over points

PostGIS trac at osgeo.org
Mon Jun 17 07:45:26 PDT 2019


#4372: PROJ 6: 4x slowdown over points
-------------------------+---------------------------
  Reporter:  Algunenano  |      Owner:  Algunenano
      Type:  defect      |     Status:  assigned
  Priority:  high        |  Milestone:  PostGIS 3.0.0
 Component:  postgis     |    Version:  trunk
Resolution:              |   Keywords:
-------------------------+---------------------------

Comment (by Algunenano):

 Digging deeper: these are the functions affected by the slowdown (apart
 from transform, which is fixed by one of my patches):

 - `TWKBFromLWGEOM`.

 - `TWKBFromLWGEOMArray`.

 - `geography_in` / `geography_from_text` / `geography_from_geometry` /
 `geography_from_geometry` / `geography_recv` / `geography_typmod_in` as
 they call `srid_check_latlong`.

 - `geography_centroid` / `geography_distance_knn` /
 `geography_distance_uncached` / `geography_distance` / `geography_dwithin`
 / `geography_distance_tree` / `geography_dwithin_uncached` /
 `geography_area` / `geography_perimeter` / `geography_length` /
 `geography_project` / `geography_azimuth` as they call
 `spheroid_init_from_srid`.


 An example with the same query using ST_AsTWKB: 404ms in PROJ5 vs 1230ms
 in PROJ6.

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