[postgis-users] GiST questions

[strk at refractions.net]

On Fri, Oct 15, 2004 at 01:19:32AM -0700, Michael Mallete wrote:
> hello everyone!
> 
> i've been testing this postgresql-8.0beta windows port
> with postgis-0.9.

beta2?3?

> 
> anyway, data query is painfully slow. so what i did
> was to make use of GiST.
> 
> but when i did, when i run vacuum analyze; it stops
> when it reaches the geometry column part.

what do you mean by 'stops' ? does it crash ?

> 
> my question is how do you properly build GiST indexes?
> is there an index naming convention, like:
> 
> CREATE INDEX certainnamingconvention ON spatialtable 
>   USING GIST ( geom GIST_GEOMETRY_OPS ); 
> 
>  or i could randomly create the index name:
> 
> CREATE INDEX randomindexname ON spatialtable 
>   USING GIST ( geom GIST_GEOMETRY_OPS ); 
> 
> hope you guys can help me out. thanx in advance! :)

you can choose a random name (as far as it's legal and
available).

--strk;

> 
> 
> 		
> _______________________________
> Do you Yahoo!?
> Declare Yourself - Register online to vote today!
> http://vote.yahoo.com
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users