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

Daniel Morissette dmorissette at DMSOLUTIONS.CA
Wed Jul 13 09:52:55 EDT 2005

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 Morissette               dmorissette at dmsolutions.ca
  DM Solutions Group              http://www.dmsolutions.ca/

More information about the mapserver-dev mailing list