[postgis-tickets] [PostGIS] #2365: find_srid performance regression with large numbers of tables

[PostGIS]

#2365: find_srid performance regression with large numbers of tables
------------------------+---------------------------
  Reporter:  angrygoat  |      Owner:  pramsey
      Type:  defect     |     Status:  reopened
  Priority:  medium     |  Milestone:  PostGIS 2.2.0
 Component:  postgis    |    Version:  2.0.x
Resolution:             |   Keywords:
------------------------+---------------------------

Comment (by robe):

 Okay I think I got it.  I don't need to change as much as I thought I
 needed to change to make this fast.  It seems to be the declaration at the
 top causing all the mischief

 If I leave the function as it was but change this
 {{{
 DECLARE
         schem text;
         tabl text;
         sr int4;
 }}}


 to


 {{{
 DECLARE
         schem varchar;
         tabl varchar;
         sr int4;
 }}}


 Then seems performance is almost as good as the one I had not doing any
 checking and not having any error handler.  More tests and I'll commit.

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