[postgis-tickets] [PostGIS] #3092: Slow performance of geometry_columns in PostGIS >= 2

[PostGIS]

#3092: Slow performance of geometry_columns in PostGIS >= 2
--------------------------+---------------------------
  Reporter:  rouault      |      Owner:  pramsey
      Type:  enhancement  |     Status:  new
  Priority:  high         |  Milestone:  PostGIS 2.1.8
 Component:  postgis      |    Version:  2.0.x
Resolution:               |   Keywords:
--------------------------+---------------------------

Comment (by robe):

 Once I can compile again after #3102 is fixed, I'll commit my changes.

 pramsey,
 BTW I tried inlining the regex_match line of your functions in the new
 query and while I can, it has a performance penalty.

 The timing for all pull then becomes the same as the geom array solution.
 So I lose 450ms of time and some time on the others as well (that was just
 trying with replacing the srid one).  I'm debating if that is worthwhile
 especially since the existing solution (used since PostGIS 2.0 doesn't use
 regexp).

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