<html dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" id="owaParaStyle"></style>
</head>
<body fpstyle="1" ocsi="0">
<div style="direction: ltr;font-family: Tahoma;color: #000000;font-size: 10pt;">
<div style="direction:ltr; font-family:Tahoma; color:#000000; font-size:10pt">
<div>Hi Paul,</div>
<div> Fortunately I'm not cursed with enough budget to worry about what the Ducati equivalent would be... . :)</div>
<div> The VMWare host in question is dedicated to GIS applications, so the virtualization layer probably isn't the primary issue, it sounds like. Oh well. Time to get some fast disks... .</div>
<div><br>
</div>
<div>Steve</div>
<div><br>
</div>
<br>
<div><br>
<div style="font-family:Tahoma; font-size:13px">
<div style="font-family:Tahoma; font-size:13px">
<div class="WordSection1">
<p class="MsoNormal"><img src="http://sig.cmparks.net/cmp-ms-90x122.png" alt="http://sig.cmparks.net/cmp-ms-90x122.png" align="left" hspace="12" height="122" width="90">
<span style="font-size:14.0pt; font-family:"Arial","sans-serif"; color:#006C56">Stephen V. Mather<br>
</span><span style="font-size:11.0pt; font-family:"Arial","sans-serif"; color:#006C56">GIS Manager<br>
</span><span style="font-size:9.0pt; font-family:"Arial","sans-serif"; color:#006C56">(216) 635-3243 (Work)
</span><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1F497D"><a href="http://www.clemetparks.com" target="_blank"><span style=""><br>
clevelandmetroparks.com</span></a></span></p>
<p class="MsoNormal"></p>
<br>
</div>
<div class="WordSection1"><br>
</div>
<div class="WordSection1"><br>
</div>
</div>
<div></div>
</div>
</div>
<div style="font-family:Times New Roman; color:#000000; font-size:16px">
<hr tabindex="-1">
<div id="divRpF250081" style="direction:ltr"><font face="Tahoma" size="2" color="#000000"><b>From:</b> postgis-users-bounces@lists.osgeo.org [postgis-users-bounces@lists.osgeo.org] on behalf of Paul Ramsey [pramsey@opengeo.org]<br>
<b>Sent:</b> Saturday, January 12, 2013 8:18 PM<br>
<b>To:</b> PostGIS Users Discussion<br>
<b>Subject:</b> Re: [postgis-users] VMWare and PostGIS<br>
</font><br>
</div>
<div></div>
<div>
<div dir="ltr">The most important thing is to figure out where your "fast enough" place is, and not get too hung up on the "fastest" thing. If we wanted to be fastest, we'd all drive Ducatis to work, but clearly fast enough works for most of us.
<div><br>
</div>
<div>The main problem with AWS is not the virtualization, it's the shared tenancy. It's possible for other tenants to saturate the I/O at unpredictable times, taking it from acceptable to non-existent, with no predicability. This will be true, though to a lesser
extent, with private virtual environments, like shared VMWare hosts run by your IT department. ("To a lesser extent" because AWS storage is network mounted, so everything the host does with I/O has to push out through a network pipe. Your IT department VMWare
host, on the other hand, will at least have separate network and storage I/O channels.)</div>
<div><br>
</div>
<div style="">I have heard of, but never seen, VMWare hosts that attach directly to SAN storage over iSCSI. So the host is virtual, but the storage is at full SAN speed. A "best of both worlds" situation, but with the added cost of SAN infrastructure.</div>
<div style=""><br>
</div>
<div style="">P.</div>
</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On Sat, Jan 12, 2013 at 4:36 PM, Stephen V. Mather <span dir="ltr">
<<a href="mailto:svm@clevelandmetroparks.com" target="_blank">svm@clevelandmetroparks.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex; border-left:1px #ccc solid; padding-left:1ex">
<div>
<div style="direction:ltr; font-size:10pt; font-family:Tahoma">
<div>Hi All,</div>
<div><span style="white-space:pre-wrap"></span>I should have asked this a long time ago regarding performance... . So the classic storage solution (AFAIK) for a spatial database is RAID 10 for maximum read and write speed. I have a RAID 10 running under a
virtualization layer (VMWare in this case) and my sustained read speeds are in the 1Gbps range. The hardware is oldish, but they are 10k SAS drives, so I would expect something a bit faster.</div>
<div> To the question-- I know virtualization makes a (not-so-good) difference in performance running spatial databases on e.g. Amazon EC2 instances. I assume this penalty is paid even for dedicated private clouds. What is the consensus/experience
with virtualization? For my next machine, should I keep it to bare metal for the PostGIS portion?</div>
<div><br>
</div>
<div>Thanks in advance,</div>
<div>Best,</div>
<div>Steve</div>
<div><br>
<div style="font-family:Tahoma; font-size:13px">
<div style="font-family:Tahoma; font-size:13px">
<div>
<p class="MsoNormal"><img alt="http://sig.cmparks.net/cmp-ms-90x122.png" align="left" hspace="12" height="122" width="90">
<span style="font-size:14.0pt; font-family:"Arial","sans-serif"; color:#006c56">Stephen V. Mather<br>
</span><span style="font-size:11.0pt; font-family:"Arial","sans-serif"; color:#006c56">GIS Manager<br>
</span><span style="font-size:9.0pt; font-family:"Arial","sans-serif"; color:#006c56"><a href="tel:%28216%29%20635-3243" value="+12166353243" target="_blank">(216) 635-3243</a> (Work)
</span><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#1f497d"><a href="http://www.clemetparks.com" target="_blank"><span><br>
clevelandmetroparks.com</span></a></span></p>
<p class="MsoNormal"></p>
<br>
</div>
</div>
<div></div>
</div>
</div>
</div>
</div>
<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
<br>
</blockquote>
</div>
<br>
</div>
</div>
</div>
</div>
<style type="text/css">
<!--
-->
</style></div>
<style type="text/css"></style>
</body>
</html>