[postgis-users] GiST questions

[Michael Mallete]

Good day gentlemen! thanx for the reply.

anyway i'm using postgresql 8.0 beta 2 dev 3.

by "stop" i mean it just stopped. no error messages,
it just stopped processing. the command prompt just
didn't return anything anymore. i did the same in
pgadminIII and the same result. processing just
stopped. and the "ok" command was still disabled. i
checked the task manager and  there was very little
cpu usage so i bet it's no longer processing that
command. i waited for about 20mins and nothing
happened.

but when i rebooted and tried it again, this time it
worked. that's really weird. perhaps this is a
hardware issue already or something (i'm using an old
dell precision workstation on a win2k platform). 

anyway, i'll be posting further observations. i'm
really sorry for the interruption sirs. 

thank you so much for your responses! :)


--- Benjamin Wragg <bwragg at tpg.com.au> wrote:

> 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
>  
> 
> 



		
_______________________________
Do you Yahoo!?
Declare Yourself - Register online to vote today!
http://vote.yahoo.com