[Mapserver-users] Finding Extent
gayathri at ou.edu
Sun May 9 16:29:29 EDT 2004
I am having a problem with figuring the best possible way to find extent
of my results for my mapping application..
My present query is:
from nc where parcels_id in (<list of parcels>);"
But this ends up being a index scan on the parcels_id...and costs of
this query are directly tied to the number of parcels in my results.
I have indexes on the_geom, oid and parcels_id
I have done a vacuum analyze on this database.
But nothing seems to help the runtime of this query.
Version of Postgresql is 7.2.1
Version of Postgis is 0.7.5
What am I doing wrong? Is there a better way to find extents for
More information about the mapserver-users