[postgis-users] PostGIS, Mapserver and itemquery question froma newbie

[coldwell at csptexas.com]

Thanks, Dave. I had already built the indexes, though I had not done the vacuum analyse.
So I built them again, and did the analyze step. But still, the PostGIS
version takes about 2 minutes of frantic disk activity  to display the map, but the
Shapefile version takes five seconds. I'm using the RPM versions of PostGIS, PostgreSQL, etc.,
from the PostGIS site on Fedora Core 1.

> 
> Put indexes on your table:
> 
> create index prop_idx_id on <table> (prop_id);
> create index oid_idx on <table> (oid);
> vacuum analyse;
> 
> dave
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>