#582 closed defect (fixed)
Use the estimateExtents function for PostGIS and PostgreSQL 8
| Reported by: | jpalmer | Owned by: | jef |
|---|---|---|---|
| Priority: | minor: annoyance | Milestone: | |
| Component: | Data Provider | Version: | Trunk |
| Keywords: | postgis extents | Cc: | |
| Must Fix for Release: | No | Platform: | All |
| Platform Version: | Awaiting user input: | no |
Description
Currently the POSTGIS data provider use the "extents" function to determine the layers spatial extents. This can take time on very large tables. Starting from PostgreSQL 8.0 the column's statistics are stored. This means that the geometry extents can be cached during statistic gathering. The POSTGIS team have added a function that returns the estimated extents "estimateExtents".
This function should be used by the data provider when the server version is greater than 8.0.
The inconvenience of not having the precise extent does not out weight the need for quick data provider creation. If it becomes an issue for the user the database admin should schedule regular table statistics updates.
Change History (4)
comment:1 by , 16 years ago
| Awaiting user input: | unset |
|---|---|
| Owner: | changed from to |
| Status: | new → assigned |
comment:2 by , 16 years ago
| Owner: | changed from to |
|---|---|
| Status: | assigned → new |
comment:3 by , 16 years ago
| Resolution: | → fixed |
|---|---|
| Status: | new → closed |
Note:
See TracTickets
for help on using tickets.
added in r9183