<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"Bauhaus 93";
panose-1:4 3 9 5 2 11 2 2 12 2;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:595.3pt 841.9pt;
margin:70.85pt 3.0cm 70.85pt 3.0cm;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=PT link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Mr Jackie,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'>It’s obvious you’re
pulling out straws since it’s apparent that you don’t have a clue
how to even benchmark Postgresql.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'>Solutions are as good as
the one who develops them.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'>My best advice to you is
that, beyond asking for free papers/experience, you should first take the time to
experiment/study Posgresql and specifically PostGIS extensions, know how to
benchmark your own implementations and then compare the same line of though
with other products.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'>Speaking strictly for myself,
my company uses PG/PostGIS *<b><span style='font-weight:bold'>extensively</span></b>*
with tables spanning millions of records and we still tip the hat to the
PG/PostGIS developers.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'>Robustness is a given as
well as scalability and stability. In short, PG/PostGIS rocks!<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'>Building a SDB is more
complex than you can now imagine and it’s a multidisciplinary task. <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'>Tip: start with asking
small questions (reflecting your commitment/investment to PG/PostGIS). This group
is a very friendly bunch (and helpful) when someone asks specific/informed
questions.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span lang=EN-GB
style='font-size:10.0pt;font-family:Arial;color:navy'>Sincerely,<o:p></o:p></span></font></p>
<div>
<p class=MsoNormal><u><font size=5 color="#0080c0" face="Bauhaus 93"><span
style='font-size:18.0pt;font-family:"Bauhaus 93";color:#0080C0'>Pedro Doria
Meunier</span></font></u><font color=navy><span style='color:navy'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>(351) 91 302 49 72 - (351) 96 247 99 12</span></font><font
color=navy><span style='color:navy'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>MSN - <a href="mailto:pdoriam@hotmail.com">pdoriam@hotmail.com</a></span></font><font
color=navy><span style='color:navy'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>ICQ - 308-182-126<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Skype: pdoriam</span></font><font
color=navy><span style='color:navy'><o:p></o:p></span></font></p>
</div>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span lang=EN-US style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span lang=EN-US
style='font-size:10.0pt;font-family:Tahoma;font-weight:bold'>From:</span></font></b><font
size=2 face=Tahoma><span lang=EN-US style='font-size:10.0pt;font-family:Tahoma'>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <b><span
style='font-weight:bold'>On Behalf Of </span></b>zhang Jackie<br>
<b><span style='font-weight:bold'>Sent:</span></b> quarta-feira, 22 de Novembro
de 2006 1:32<br>
<b><span style='font-weight:bold'>To:</span></b>
postgis-users@postgis.refractions.net<br>
<b><span style='font-weight:bold'>Subject:</span></b> [postgis-users] build a
SDB cache for Spatial Database based onpostgis and postgresql</span></font><span
lang=EN-US><o:p></o:p></span></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face=Verdana><span style='font-size:12.0pt;
font-family:Verdana'> I am interesting in PostGis and want to
do something on it. My idea is to build a Spatial Database Cache to accelerate
GIS applications .So I want to ask you some question and hope to get your
answer. </span></font><o:p></o:p></p>
<div>
<p class=MsoNormal><font size=3 face=Verdana><span style='font-size:12.0pt;
font-family:Verdana'> 1. As we all know, PostGis is a Spatial
extention for PostGreSQL. And there are also some other products such as
ArcSDE, Oracle Spatial .Have you ever do some performance comparison between
them.If you have ever done such work,Could you give me some information on it.
If not, is it because that you team did not care about performance and just
concerned with correctness of the program. And if you can give me some
materials on performance comparison on such Spatial Database extention
including ArcSDE, Oracle Spatial ,MySQL ,etc. </span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><font size=3 face=Verdana><span style='font-size:12.0pt;
font-family:Verdana'> 2. Since Google Earth is lauched ,Many
GIS systems are used by more and more people,so the important features of
Software becomes more and more important,such as sacalibity, robust,
stability,etc. Can you give me some information and papers on the bottleneck of
these applications.Especially, are computing and I/O requirements very
important and become bottlenecks,Of course, If you know some related solutions
, you can mail me.</span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><font size=3 face=Verdana><span style='font-size:12.0pt;
font-family:Verdana'> I have searche lots of papers and get an
overview of it. But I felt I did not figure out the truth. So I want to
get some more accurate information on this field. </span></font><o:p></o:p></p>
</div>
</div>
</body>
</html>