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

Comment (by robe):

 Hmm why aren't you using clock_timestamp().  I think that is less prone to
 vagaries of transactions.

 BTW did a quick test with if you have just typmod tables (30,000 columns)
 on 9.3, and happy to say for a pure typmod system, the timings of old and
 new are the same (aside from the count(*) which still suffers a penalty
 for some reason).

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