[postgis-tickets] [PostGIS] #3011: ST_EstimatedExtent return a incorrect extent value

PostGIS trac at osgeo.org
Sun Jan 11 23:30:33 PST 2015


#3011: ST_EstimatedExtent return a incorrect extent value
--------------------------------+-------------------------------------------
 Reporter:  rockyc              |       Owner:  pramsey
     Type:  defect              |      Status:  new    
 Priority:  medium              |   Milestone:         
Component:  postgis             |     Version:  2.1.x  
 Keywords:  ST_EstimatedExtent  |  
--------------------------------+-------------------------------------------

Comment(by rockyc):

 Replying to [comment:3 pramsey]:
 > The estimate is based on a sample. Changing the rows changes which
 subset gets picked for the sample, getting a smaller box is not
 unreasonable.

 You means, its results is only based on a sample, and can be changed
 dramatically dependent on the picked sample.

 If I understand correctly, does it mean, sometimes, the return box is
 smaller than the value return from ST_Extent, and sometimes is larger, and
 also, the difference between ST_EstimatedExtent and ST_Extent can be a big
 value, right?

 If it is true, do you have some guidance on when,where and how to use
 ST_EstimatedExtent.

 Thanks

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