<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
--></style>
</head>
<body class='hmmessage'>
<div>Hi Chris</div><div><br></div><div>when i say "slow", i refer that is no so fast than googleMaps, extreme example.!!!</div><div><br></div><div>This is a url with one commune, http://mapas.observatoriourbano.cl/localizacion/map.phtml?config=7101</div><div><br></div><div>In this case, we have 11 layer in database format (Geographic data). </div><div>if you multiply 11 by 270 comunnes in my country, we have 2970 tables aprox, <span class="Apple-style-span" style="text-decoration: underline;">a</span><span class="Apple-style-span" style="text-decoration: underline;">nd when i do a zoom over a area, this show the area, but "slow".</span></div><div><br></div><div><br></div><div>for this, I don't do anything relationated with WHERE clause, i don't use dificult SQL, just show the layer in the mapfile with: </div><div><br></div><div>"DATA the_geom from (SELECT the_geom,gid FROM vii_talca_areacomunal) AS pas_pred3 USING UNIQUE gid USING SRID=-1"</div><div><br></div><div>as a complement </div><div>in Hardware, i have two Virtual Machine:</div><div>1.- Database server, AMD Opteron 64, 2,4 Ghz, 4GB Ram</div><div>2.- Page server, AMD Opteron 64, 2,4 Ghz, 2GB Ram</div><div><br></div><div>in Software, </div><div>Linux fedora, php pages, apache, postgresql with postgis, mapserver and p.mapper</div><div><br></div><div>I don't know what i have to do, to do it map more fast !!!!</div><div><br></div><div>thank very much.!!!!</div><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><br><br><br><br>> From: chris.hermansen@timberline.ca<br>> To: postgis-users@postgis.refractions.net<br>> Date: Tue, 29 Dec 2009 11:07:39 -0800<br>> Subject: Re: [postgis-users] GIST INDEX!!<br>> <br>> César;<br>> <br>> You need to be a bit more specific about what you mean by "slow". What<br>> operations precisely are slow?<br>> <br>> Having said that, in general any columns - spatial or otherwise - to<br>> which you refer in WHERE clauses in your SELECT statements should be<br>> considered for indexing, especially if you use them in join conditions.<br>> If you have a specific SELECT statement that gives you problems, you<br>> might try using an EXPLAIN or ANALYZE together with the statement as for<br>> example in<br>> <br>> http://www.postgresql.org/docs/8.1/static/sql-explain.html<br>> <br>> 2700 tables - that is a lot of tables. I have no idea if such a large<br>> number of tables will slow down query execution, but it seems possible.<br>> <br>> Do you really need that many tables? For example, if you have all the<br>> IGM shape files by map sheet for loading, you don't need to create a<br>> table for each shape file. Rather you might put all the different<br>> "caminos" shape files into one table, and the "comunas" into another,<br>> and so on. Sorry I'm just guessing at what you might be doing here, if<br>> I'm wrong please ignore!<br>> <br>> La documentación de PostgreSQL es disponible en castellano, por ejemplo<br>> en el sitio<br>> <br>> http://palomo.usach.cl/docshtml/node4.html<br>> <br>> On Tue, 2009-12-29 at 15:38 -0300, César Medina wrote:<br>> > Dear all<br>> > <br>> > <br>> > I am trying to do a tunning to my database, and i have many doubt,<br>> > because i think that is very slow (with 3 o 4 users is slow)<br>> > <br>> > <br>> > I have 2700 tables aprox. with geometry column in my database, the<br>> > street's name, big avenues, regional boundaries, street types,comunal<br>> > areas, etc. but the tables don't have a index in the geometry<br>> > column !!!!!!! - Is recommended do a "GIST" index for each tables in<br>> > my database? - Could be more fast, if that have a gist index? - What<br>> > is the benefits ? kings regards, thank you... and happy new year.<br>> > <br>> > <br>> > PD: Frecuently i do "vacuum" and "reindex" to my database<br>> > César http://www.linkedin.com/in/cesarmedinam<br>> > http://foss4gchile.blogspot.com/ mail: ciesareMedina (at) gmail (dot)<br>> > com msn: ciesareMedina (at) hotmail (dot) com skype: ciesare_medina<br>> > <br>> > CHILE.<br>> > <br>> > <br>> > ______________________________________________________________________<br>> > Windows Live: Make it easier for your friends to see what you’re up to<br>> > on Facebook.<br>> > _______________________________________________<br>> > postgis-users mailing list<br>> > postgis-users@postgis.refractions.net<br>> > http://postgis.refractions.net/mailman/listinfo/postgis-users<br>> <br>> <br>> -- <br>> Regards,<br>> <br>> Chris Hermansen · mailto:chris.hermansen@timberline.ca<br>> tel+1.604.714.2878 · fax+1.604.733.0631 · mob+1.778.840.4625<br>> Timberline Natural Resource Group · http://www.timberline.ca<br>> 401 · 958 West 8th Avenue · Vancouver BC · Canada · V5Z 1E5<br>> <br>> <br>> _______________________________________________<br>> postgis-users mailing list<br>> postgis-users@postgis.refractions.net<br>> http://postgis.refractions.net/mailman/listinfo/postgis-users<br> <br /><hr />Windows Live Hotmail: <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_4:092009' target='_new'>Your friends can get your Facebook updates, right from Hotmail®.</a></body>
</html>