Opened 17 years ago

Closed 15 years ago

Last modified 14 years ago

#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


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 aaronr, 16 years ago

Awaiting user input: unset
Owner: changed from nobody to aaronr
Status: newassigned

comment:2 by jef, 15 years ago

Owner: changed from aaronr to jef
Status: assignednew

comment:3 by jef, 15 years ago

Resolution: fixed
Status: newclosed

added in r9183

comment:4 by (none), 14 years ago

Milestone: Version 1.0.0

Milestone Version 1.0.0 deleted

Note: See TracTickets for help on using tickets.