Dear all
I am trying to do a tunning to my database, and i have many doubt, because i
think that is very slow (with 3 o 4 users is slow)
I have 2700 tables aprox. with geometry column in my database, the street's
name, big avenues, regional boundaries, street types,comunal areas, etc.
but the tables don't have a index in the geometry column !!!!!!!
- Is recommended do a "GIST" index for each tables in my database?
- Could be more fast, if that have a gist index?
- What is the benefits ?
kings regards, thank you...
and happy new year.
PD: Frecuently i do "vacuum" and "reindex" to my database
César
http://www.linkedin.com/in/cesarmedinam
http://foss4gchile.blogspot.com/
mail: ciesareMedina (at) gmail (dot) com
msn: ciesareMedina (at) hotmail (dot) com
skype: ciesare_medina
CHILE.
_________________________________________________________________
Windows Live: Make it easier for your friends to see what you’re up to on
Facebook.
http://www.microsoft.com/middleeast/windows/windowslive/see-it-in-action/social-network-basics.aspx?ocid=PID23461::T:WLMTAGL:ON:WL:en-xm:SI_SB_2:092009
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
