[postgis-tickets] [PostGIS] #2998: Define a strategy to ensure stats are collected during topology building

PostGIS trac at osgeo.org
Thu Nov 20 03:41:55 PST 2014


#2998: Define a strategy to ensure stats are collected during topology building
-------------------------+--------------------------------------------------
 Reporter:  strk         |       Owner:  strk          
     Type:  enhancement  |      Status:  new           
 Priority:  medium       |   Milestone:  PostGIS Future
Component:  topology     |     Version:  trunk         
 Keywords:               |  
-------------------------+--------------------------------------------------
 It is very likely that the queries used during topology building are
 inefficient due to lack of statistics enabling use of indexes.

 Statistics are not updated until transaction commit, so this is a problem
 for queries like:

  UPDATE mycoverage SET topogeom = toTopoGeom(geom);

 This ticket is to define a strategy to run ANALYZE during these kind of
 operations, in a somewhat automatic but not invasive way.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2998>
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.


More information about the postgis-tickets mailing list