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

Comment (by icehong):

 It seems like proj cache doesn't take effect .

 [https://github.com/postgis/postgis/actions/runs/857694961  Lengthen proj
 cache lifetime to the life of the backend, and move mem… CI #193:]


 {{{
 PostgreSQL 13.1 on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.0-16)
 10.2.0, 64-bit
   Postgis 3.1.2dev - (695dc14) - 2021-05-19 17:21:57
   scripts 3.1.2dev 695dc14
   raster scripts 3.1.2dev 695dc14
   GEOS: 3.8.2dev-CAPI-1.13.3
   PROJ: 7.1.1
   SFCGAL: 1.3.9
   GDAL: GDAL 3.1.4, released 2020/10/20
   ./regress/core/regress_proj_basic .. ok in 49 ms
   ./regress/core/regress_proj_adhoc .. ok in 414 ms
   ./regress/core/regress_proj_cache_overflow .. ok in 1352 ms
   ./regress/core/regress_proj_4890 .. ok in 56 ms

 PostgreSQL 12.5 on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.0-16)
 10.2.0, 64-bit
   Postgis 3.1.2dev - (695dc14) - 2021-05-19 17:21:55
   scripts 3.1.2dev 695dc14
   raster scripts 3.1.2dev 695dc14
   GEOS: 3.7.3dev-CAPI-1.11.3 4ae53b7
   PROJ: 6.1.1
   SFCGAL: 1.3.9
   GDAL: GDAL 3.0.4, released 2020/01/28
   ./regress/core/regress_proj_basic .. ok in 46 ms
   ./regress/core/regress_proj_adhoc .. ok in 160 ms
   ./regress/core/regress_proj_cache_overflow .. ok in 3307 ms
   ./regress/core/regress_proj_4890 .. ok in 48 ms

 PostgreSQL 11.10 on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-3)
 10.2.1 20201224, 64-bit
   Postgis 3.1.2dev - (695dc14) - 2021-05-19 17:21:40
   scripts 3.1.2dev 695dc14
   raster scripts 3.1.2dev 695dc14
   GEOS: 3.7.4dev-CAPI-1.11.4 2926110
   PROJ: Rel. 5.2.0, September 15th, 2018
   SFCGAL: 1.3.9
   GDAL: GDAL 2.4.4, released 2020/01/08
   ./regress/core/regress_proj_basic .. ok in 14 ms
   ./regress/core/regress_proj_adhoc .. ok in 14 ms
   ./regress/core/regress_proj_cache_overflow .. ok in 37 ms
   ./regress/core/regress_proj_4890 .. ok in 16 ms

 }}}

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