[postgis-users] GiST questions

[Benjamin Wragg]

The name doesn't make any difference your problem is elsewhere. What do you
mean it stop on the geometry column part. Do you have any errors

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Michael
Mallete
Sent: Friday, 15 October 2004 6:20 PM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] GiST questions

hello everyone!

i've been testing this postgresql-8.0beta windows port with postgis-0.9.

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.

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! :)


		
_______________________________
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

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.777 / Virus Database: 524 - Release Date: 14/10/2004
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.777 / Virus Database: 524 - Release Date: 14/10/2004