[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:  closed
  Priority:  medium     |  Milestone:  PostGIS 2.1.8
 Component:  postgis    |    Version:  2.0.x
Resolution:  fixed      |   Keywords:  history
------------------------+---------------------------

Comment (by robe):

 Although I changed the find_srid to be the same in 2.1, the marked
 improvement only seems to happen with the combination of removing the cast
 from geometry_columns view (done in 2.2, but can't in 2.1 because it
 requires column type change) and also the change in find_srid.

 I think find_srid id performance is still better though but not like a
 super improvement and way too painful to run looking up all 30,000.

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