[postgis-users] Re: [postgis-users] Postgis too slow

[shpr@libero.it]

Yes, I have done it.

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