[postgis-tickets] [PostGIS] #3103: geometry_columns, find_srid performance regress tests

[PostGIS]

#3103: geometry_columns, find_srid performance regress tests
----------------------+---------------------------
  Reporter:  robe     |      Owner:  robe
      Type:  task     |     Status:  new
  Priority:  medium   |  Milestone:  PostGIS 2.2.0
 Component:  postgis  |    Version:  2.1.x
Resolution:           |   Keywords:
----------------------+---------------------------

Comment (by robe):

 Nope (removing STRICT Of course so it can inline) and when I tried making
 it an SQL function, I ran into another problem.  Since PostgreSQL can see
 into an SQL function, it complained that the view didn't exist when I
 tried to upgrade.  I guess because I dropped the view at beginning.  Not
 sure.  I have to revisit that.  I was thinking this function should really
 be SQL stable rather than IMMUTABLE.

 I'm still really puzzled how that seemingly simple condition could have
 such major speed consequences.  Makes me concerned something else is up.

--
Ticket URL: <http://trac.osgeo.org/postgis/ticket/3103#comment:5>
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.