[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:  new          
 Priority:  medium     |   Milestone:  PostGIS 2.0.4
Component:  postgis    |     Version:  2.0.x        
 Keywords:             |  
-----------------------+----------------------------------------------------

Comment(by angrygoat):

 Hey

 I've managed to work around by avoiding the find_srid() call in the
 frequently executed query (just telling mapserver the SRID) – just logged
 this because I didn't want other people to fall down the same hole.

 You can reproduce this by just creating a bunch of plain non-geometry
 tables, so I don't know about typmod vs. constraints mattering. The one
 geometry table my script makes is typmod though.

 Thanks for all the help!

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