[Geoserver-devel] [jira] (GEOS-5233) Calculating layer extents with ST_Estimate_Extents requires updated statistics

GeoServer GeoServer Developer
,
1

Marc Pfister created BugGEOS-5233
Calculating layer extents with ST_Estimate_Extents requires updated statistics

Issue Type:

BugBug

Assignee:

Andrea Aime

Components:

PostGIS

Created:

23/Jul/12 2:10 PM

Description:

GeoServer currently tries to use ST_Estimate_Extents to determine layer extents in PostGIS tables. ST_Estimate_Extents gets its information from the database’s statistics table. However, those statistics are only generated when ANALYZE is called. If ANALYZE has not been run recently GeoServer will retrieve bounds that are out of date. Ideally GeoServer should run ANALYZE first, or it should be possible to disable the use estimated extents.

Project:

GeoServer

Priority:

MajorMajor

Reporter:

Marc Pfister
This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your [JIRA administrators](https://jira.codehaus.org/secure/ContactAdministrators!default.jspa). For more information on JIRA, see: [http://www.atlassian.com/software/jira](http://www.atlassian.com/software/jira)