[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] PostGIS,
From:       coldwell () csptexas ! com
Date:       2004-03-29 19:54:49
Message-ID: dsezft4f.z02t3kwwzbcg () SpaceShuttle
[Download RAW message or body]

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@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 


[prev in list] [next in list] [prev in thread] [next in thread]