[postgis-users] Postgis too slow

[Paul Ramsey]

And you've done a 'vacuum analyze' on your database?



Stefano Bonnin wrote:
> 
> 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
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users