<br><br><div class="gmail_quote">On Sat, Jan 12, 2013 at 11:39 PM, Paragon Corporation <span dir="ltr"><<a href="mailto:lr@pcorp.us" target="_blank">lr@pcorp.us</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<u></u>
<div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">On a related topic, has anyone tried the VMware Postgres
product. I'd be curious to know how they optimized the performance for
that and if it supports PostGIS. I assume it does, but perhaps David
Fetter if he's listening can fill us in on that.</font></span></div></div></blockquote><div><br></div><div>I've used it a fair amount. Most of the performance optimizations are around tuning, but they do have a cool feature where you can increase shared buffers without restarting. The source is open so you can diff it against 9.1.6 and see what they did.</div>
<div><a href="https://my.vmware.com/web/vmware/details?downloadGroup=VFPG_9160_OSS_OSE&productId=274">https://my.vmware.com/web/vmware/details?downloadGroup=VFPG_9160_OSS_OSE&productId=274</a></div><div><br></div>
<div>The base database would support PostGIS, but I don't recall if its possible through their Data Director interface. Data Director basically abstracts away creating and running the database a little and in trade, you don't have superuser rights. VMware would need to enable it through Data Director somehow because a regular user couldn't enable it.</div>
<div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"><a href="http://www.vmware.com/products/application-platform/vfabric-postgres/overview.html" target="_blank">http://www.vmware.com/products/application-platform/vfabric-postgres/overview.html</a></font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">Thanks,</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" face="Arial">Regina</font></span></div><br>
<div dir="ltr" lang="en-us" align="left">
<hr>
<font face="Tahoma"><b>From:</b> <a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a>
[mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a>] <b>On Behalf Of </b>Paul
Ramsey<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 class="h5">
<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>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><br></div>
<div>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 style="BORDER-LEFT:#ccc 1px solid;MARGIN:0px 0px 0px 0.8ex;PADDING-LEFT:1ex" class="gmail_quote">
<div>
<div style="FONT-FAMILY:Tahoma;DIRECTION:ltr;FONT-SIZE:10pt">
<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 hspace="12" alt="http://sig.cmparks.net/cmp-ms-90x122.png" align="left" width="90" height="122"> <span style="FONT-FAMILY:'Arial','sans-serif';COLOR:#006c56;FONT-SIZE:14pt">Stephen
V. Mather<br></span><span style="FONT-FAMILY:'Arial','sans-serif';COLOR:#006c56;FONT-SIZE:11pt">GIS
Manager<br></span><span style="FONT-FAMILY:'Arial','sans-serif';COLOR:#006c56;FONT-SIZE:9pt"><a href="tel:%28216%29%20635-3243" value="+12166353243" target="_blank">(216)
635-3243</a> (Work) </span><span style="FONT-FAMILY:'Calibri','sans-serif';COLOR:#1f497d;FONT-SIZE:11pt"><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>
<br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">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>