[postgis-users] Postgis too slow

[Stefano Bonnin]

I didn't say that but I created an index on oid
and a spatial index on the_geom column.

Postgis takes about 3 minutes in order to do the query!!

I think that Postgis doesn't use the indexes that I defined. But WHY?
 
----- Original Message ----- 
From: "Dave Blasby" <dblasby at refractions.net>
To: <postgis-users at postgis.refractions.net>
Sent: Thursday, May 16, 2002 6:32 PM
Subject: Re: [postgis-users] Postgis too slow


> You didnt create the spatial index!!
> 
> create index <index name> on <table> using gist (<geom column name>
> gist_geometry_ops)
> 
> dave
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users


---
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