[postgis-tickets] [PostGIS] #4890: ST_Transform large slow down from upgrade to 3.1.1 from 2.4

[PostGIS]

#4890: ST_Transform large slow down from upgrade to 3.1.1 from 2.4
------------------------+---------------------------
 Reporter:  SAbernethy  |      Owner:  pramsey
     Type:  defect      |     Status:  new
 Priority:  medium      |  Milestone:  PostGIS 3.1.2
Component:  postgis     |    Version:  3.1.x
 Keywords:              |
------------------------+---------------------------
 The issue is that the ST_Transform function inside postgis when upgraded
 from 2.4 to either 3.0.3 or 3.1.1 runs about 20 times slower. This is
 regardless of the version of postgres, We are currently running PG11 and
 are upgrading to PG13 and are having to upgrade postgis version due to 2.4
 not being supported in PG13.

 Attached is the timings for the diffrent postgis

 How to reproduce
 setup postgres either 11 or 13,
 install postgis version 2.4 / 3.03 / 3.11
 create empty database
 install posgis
 and run the following query "select
 ST_Transform('0103000020C90800000100000005000000000000008
 CAE264100000000BCA34641000000008CAE264100000000CDA3464100
 000000C2AE264100000000CDA3464100000040C3AE264100000000BCA
 34641000000008CAE264100000000BCA34641'::geometry,4326);"

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4890>
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.