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

PostGIS trac at osgeo.org
Wed Jan 18 07:49:27 PST 2012


#818: ANALYZE does not override statistics on empty table
----------------------+-----------------------------------------------------
  Reporter:  strk     |       Owner:  pramsey      
      Type:  defect   |      Status:  closed       
  Priority:  medium   |   Milestone:  PostGIS 2.0.0
 Component:  postgis  |     Version:  trunk        
Resolution:  fixed    |    Keywords:               
----------------------+-----------------------------------------------------
Changes (by strk):

  * status:  new => closed
  * resolution:  => fixed


Comment:

 r8870 doesn't override statistics but changes st_estimated_extent to deal
 with the empty table case by looking at the core statistics (row count).

 Such change fixes the TRUNCATE effect.
 I don't think we care about having correct statisticts on empty tables for
 other uses as any plan the planner makes it will still be very fast for an
 empty table...

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/818#comment:6>
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-devel mailing list