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

PostGIS trac at osgeo.org
Mon Apr 19 00:07:37 PDT 2021


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

 Hello SAbernethy

 will you be able to rewrite your simple function from plpgsql into sql
 language function? replace "return" with "select", drop the begin/end and
 change language. It should become much faster.

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