[PostGIS] #5807: Joined table ST_Transform runs on each filter evaluation instead of just once per input row

[PostGIS]

#5807: Joined table ST_Transform runs on each filter evaluation instead of just
once per input row
----------------------+---------------------
  Reporter:  lnicola  |      Owner:  pramsey
      Type:  defect   |     Status:  new
  Priority:  medium   |  Milestone:
 Component:  postgis  |    Version:  3.5.x
Resolution:           |   Keywords:
----------------------+---------------------
Comment (by robe):

 Just to confirm it's not something special about this dataset, I created a
 dummy example attached:

 {{{
 \i ticket_transform_issue.sql
 }}}

 outputs


 {{{


    funcname    | calls | total_time
 ---------------+-------+------------
  st_transform  | 11090 |      5.841
  st_intersects | 11084 |     14.881
 (2 rows)
 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5807#comment:7>
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.