[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.3.3
 Component:  postgis     |    Version:  3.3.x
Resolution:              |   Keywords:
-------------------------+---------------------------
Comment (by robe):

 Can you output your

 ```
 SELECT postgis_full_version();
 ```

 I don't see using ST_Transform(geom, srid)  would yield a different answer
 from ST_Transform(geom, text, srid)

 In both cases it should be using the proj.db since the proj.db takes
 precedence over waht is in spatial_ref_sys table.

 Can you output an example where


 {{{
 ST_AsText(ST_Transform(ST_SetSRID("GEOMETRY", 7844), 4326))
 }}}


 is different from


 {{{
 ST_AsText(ST_Transform("GEOMETRY", 'EPSG:7844' , 4326))
 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5387#comment:2>
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.