Suppose I want to speedup the following type of queries with an index:
SELECT the_geom, building_name
FROM buildings
WHERE Distance(the_geom, 'POINT(100312 102312)') < 5000
AND building_type = 'School'
Is that possible, and if not, why not? My current option is to write
my own index storage in C++, using a hashmap to filter building_type,
and build separate spatial indices for each building type. Can I do
something similar in postgresql? Would my only option be to split the
building_types into separate tables?
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
