Support estimated extents in postgis-ng
---------------------------------------

                 Key: GEOT-2572
                 URL: http://jira.codehaus.org/browse/GEOT-2572
             Project: GeoTools
          Issue Type: Bug
          Components: data jdbc-ng
            Reporter: Andrea Aime


The current postgis datastore allows usage of the estimated extents function to 
quickly compute bounds of multi-million row datasets quickly by fast inspection 
of the index optimizer statistics.
The NG one does not, and in order to support it, we'll need to make some API 
changes as the estimated extent is not a query that is applied on a table, but 
look like:

{code:sql}
select estimated_extent('tableName', 'columnName')
{code}

The oracle plugin needs this to use the SDO_TUNE fast bbox computations as 
well, but with a twist, in that case the function always returns a correct 
result provided the data is in a projected CS (so it's always a good choice 
with the right data set, it's not a matter of user setup).

In both cases it seems the dialect class should be modified to allow the 
specific dialect to completely take over the computation of extents for a given 
set of geometries.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

------------------------------------------------------------------------------
_______________________________________________
Geotools-devel mailing list
Geotools-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel

Reply via email to