[postgis-tickets] [PostGIS] #5387: ST_Transform(geom, str, str) is very slow

[PostGIS]

#5387: ST_Transform(geom, str, str) is very slow
-------------------------+---------------------------
  Reporter:  cdestigter  |      Owner:  pramsey
      Type:  defect      |     Status:  new
  Priority:  medium      |  Milestone:  PostGIS 3.4.0
 Component:  postgis     |    Version:  3.3.x
Resolution:              |   Keywords:
-------------------------+---------------------------
Comment (by cdestigter):

 I also find this a bit surprising (I'm not sure if it's related):

 {{{
 dbname=# select st_asewkt(st_transform('point(0 0)'::geometry,
 'EPSG:7844', 'EPSG:4283'));
  POINT(-0.000009040658614 0.000009514196768)

 dbname=# select st_asewkt(st_transform('srid=7844;point(0 0)'::geometry,
 'EPSG:4283'));
  POINT(0 0)
 }}}

 (our proj.db has an overridden custom transformation for these CRSes,
 which might explain the differences here - maybe one of these calls is
 using the custom pipeline and the other is not.) I'll try and dig into
 that behaviour a bit more tomorrow.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5387#comment:6>
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.