[postgis-users] GiST questions
Benjamin Wragg
bwragg at tpg.com.au
Fri Oct 15 01:31:51 PDT 2004
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
More information about the postgis-users
mailing list