[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:  blocker     |  Milestone:  PostGIS 3.1.2
 Component:  postgis     |    Version:  3.1.x
Resolution:              |   Keywords:
-------------------------+---------------------------

Comment (by mboeringa):

 Paul, does this also affect casts to geography of WGS1984, SRID 4326
 stored data?

 I am wondering, because I also seem to be hit this massive slow down, in a
 similar - in my case multi-threaded - processing workflow doing millions
 of separate updates.

 The code includes, as just one of many things, a calculation of geodesic
 area:


 {{{
 ST_Area(<GEOMETRY_COLUMN_IN_4236>::geography,True)
 }}}

 Would this possibly also be affected by the same issue, even though not
 explicitely calling ST_Transform?

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