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

PostGIS trac at osgeo.org
Sun Jun 18 21:55:15 PDT 2023


#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):

 Apologies, I had mis-remembered why we did this.

 It's actually because

 (a) we wanted to be able to use CRSes that Postgis doesn't know about.
 Just using an integer SRID requires that that CRS be in `spatial_ref_sys`

 (b) We wanted to ensure we have a single source of truth for CRS
 information (proj.db) - and not have to sync patches into PostGIS if we
 change proj.db by adding custom CRSes etc.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5387#comment:4>
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