<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
--></style>
</head>
<body class='hmmessage'>
<span class="Apple-style-span" style="font-family: arial, sans-serif; white-space: pre-wrap; "><div>Dear all</div><div><br></div><div>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)</div><div><br></div>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.
</span><br><div><br></div><div>PD: <span class="Apple-style-span" style="font-family: arial, sans-serif; white-space: pre-wrap; ">Frecuently i do "vacuum" and "reindex" to my database</span><br><span class="EC_EC_EC_Apple-style-span" style="color:rgb(0, 0, 0);font-family:arial;white-space:pre-wrap">
</span><div><font class="EC_EC_EC_Apple-style-span" color="#000000" face="arial"><span class="EC_EC_EC_Apple-style-span" style="white-space:pre-wrap">César
http://www.linkedin.com/in/cesarmedinam
http://foss4gchile.blogspot.com/
<span class="EC_Apple-style-span" style="border-collapse:separate">mail: ciesareMedina (at) gmail (dot) com
msn: ciesareMedina (at) hotmail (dot) com</span>
skype: ciesare_medina<br></span></font></div><div><font class="Apple-style-span" face="arial"><span class="Apple-style-span" style="white-space: pre-wrap;">CHILE.</span></font></div></div> <br /><hr />Windows Live: Make it easier for your friends to see <a href='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' target='_new'>what you’re up to on Facebook.</a></body>
</html>