[postgis-users] Postgis too slow

[Paul Ramsey]

Check some queries, do some bounding box queries using 'explain' and see
if you are getting index scans. Remember to 'vacuum analyze' your
database after building the indexes. Be peaceful and good.
P.

Stefano Bonnin wrote:
> 
> I'm using mapserver with postgis
> 
> ... but the postgis query is too slow............
> 
> I tried to create a spatial index (GIST) but the query is always slow....
> (3,4 minutes!!!!)
> 
> Why?
> 
> ---
> Outgoing mail is certified Virus Free. (FLASHH!)
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.361 / Virus Database: 199 - Release Date: 07/05/02
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

-- 
      __
     /
     | Paul Ramsey
     | Refractions Research
     | Email: pramsey@refractions.net
     | Phone: (250) 885-0632
     \_