[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