[postgis-tickets] [PostGIS] #3975: ST_Transform references spatial_ref_sys without schema

[PostGIS]

#3975: ST_Transform references spatial_ref_sys without schema
-------------------------+---------------------------
  Reporter:  javitonino  |      Owner:  pramsey
      Type:  defect      |     Status:  new
  Priority:  medium      |  Milestone:  PostGIS 2.4.3
 Component:  postgis     |    Version:  2.4.x
Resolution:              |   Keywords:
-------------------------+---------------------------

Comment (by pramsey):

 Confirmed that using search_path parameter on the function has a
 deleterious effect on performance.
 {{{
 create table pts as
   select st_setsrid(st_makepoint(random()*360 - 180,random() * 180 -
 90),4326) as geom,
   generate_series(1,100000) as id;

 select sum(st_x(st_transform(geom, 3857))) from pts;
 -- Time: 157.676 ms

 alter function st_transform(geometry, integer) set
 search_path=public,pg_catalog;

 select sum(st_x(st_transform(geom, 3857))) from pts;
 -- Time: 587.814 ms
 }}}
 Very unfortunate.

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