[postgis-devel] [PostGIS] #818: ANALYZE does not override statistics on empty table

[PostGIS]

#818: ANALYZE does not override statistics on empty table
---------------------+------------------------------------------------------
 Reporter:  strk     |       Owner:  pramsey      
     Type:  defect   |      Status:  new          
 Priority:  medium   |   Milestone:  PostGIS 2.0.0
Component:  postgis  |     Version:  trunk        
 Keywords:           |  
---------------------+------------------------------------------------------
 Dunno if postgis can do anything here or is a postgresql thing.
 What happens is that there seems to be no way to clear statistics of a
 table after truncating it.

 Try with st_estimated_extent: fill a table, analyze, get estimated extent,
 truncate, vacuum and analyze again, get estimated_extent again: you'll
 obtain the old estimate.

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