[UMN_MAPSERVER-USERS] Question re: PostGIS and MapScript getExtent() function

[Daniel Morissette]

Paul Ramsey wrote:
> Steve,
> 
> Try it on a 20M record table in Oracle. Both implementations,  Oracle's 
> and your uncommented PostGIS one, do the same functional  thing, which 
> is a full table scan.  It is possible that Oracle is  slightly smarter 
> about reading the index for the AGGR_MBR case, which  might make it work 
> better on large tables: one for the testing range.
> 

Since you guys wrote all the indexing code in postgis, would you not be 
able to add a function to fetch the real data extents from the index 
somehow? That would give fast and accurate responses all the time. Is 
this information not available in the data structures somewhere?

Daniel
-- 
------------------------------------------------------------
  Daniel Morissette               dmorissette at dmsolutions.ca
  DM Solutions Group              http://www.dmsolutions.ca/
------------------------------------------------------------