<html><body>
<p><a href="http://magazine.redhat.com/2007/12/12/tip-from-an-rhce-memory-storage-on-postgresql/">http://magazine.redhat.com/2007/12/12/tip-from-an-rhce-memory-storage-on-postgresql/</a><br>
<br>
<br>
<br>
Doug Newcomb <br>
USFWS<br>
Raleigh, NC<br>
919-856-4520 ext. 14 doug_newcomb@fws.gov<br>
---------------------------------------------------------------------------------------------------------<br>
The opinions I express are my own and are not representative of the official policy of the U.S.Fish and Wildlife Service or Dept. of the Interior. Life is too short for undocumented, proprietary data formats.<br>
<img width="16" height="16" src="cid:1__=0ABBFCCEDFF1B8F48f9e8a93df938690@fws.gov" border="0" alt="Inactive hide details for "Randy George" <rkgeorge@cadmaps.com>">"Randy George" <rkgeorge@cadmaps.com><br>
<br>
<br>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr valign="top"><td style="background-image:url(cid:2__=0ABBFCCEDFF1B8F48f9e8a93df938690@fws.gov); background-repeat: no-repeat; " width="40%">
<ul>
<ul>
<ul>
<ul><b><font size="2">"Randy George" <rkgeorge@cadmaps.com></font></b><font size="2"> </font><br>
<font size="2">Sent by: discuss-bounces@lists.osgeo.org</font>
<p><font size="2">10/28/2009 01:42 PM</font>
<table border="1">
<tr valign="top"><td width="168" bgcolor="#FFFFFF"><div align="center"><font size="2">Please respond to<br>
rkgeorge@cadmaps.com; Please respond to<br>
OSGeo Discussions <discuss@lists.osgeo.org></font></div></td></tr>
</table>
</ul>
</ul>
</ul>
</ul>
</td><td width="60%">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr valign="top"><td width="1%"><img width="58" height="1" src="cid:3__=0ABBFCCEDFF1B8F48f9e8a93df938690@fws.gov" border="0" alt=""><br>
<div align="right"><font size="2">To</font></div></td><td width="100%"><img width="1" height="1" src="cid:3__=0ABBFCCEDFF1B8F48f9e8a93df938690@fws.gov" border="0" alt=""><br>
<font size="2">"'OSGeo Discussions'" <discuss@lists.osgeo.org></font></td></tr>
<tr valign="top"><td width="1%"><img width="58" height="1" src="cid:3__=0ABBFCCEDFF1B8F48f9e8a93df938690@fws.gov" border="0" alt=""><br>
<div align="right"><font size="2">cc</font></div></td><td width="100%"><img width="1" height="1" src="cid:3__=0ABBFCCEDFF1B8F48f9e8a93df938690@fws.gov" border="0" alt=""><br>
</td></tr>
<tr valign="top"><td width="1%"><img width="58" height="1" src="cid:3__=0ABBFCCEDFF1B8F48f9e8a93df938690@fws.gov" border="0" alt=""><br>
<div align="right"><font size="2">Subject</font></div></td><td width="100%"><img width="1" height="1" src="cid:3__=0ABBFCCEDFF1B8F48f9e8a93df938690@fws.gov" border="0" alt=""><br>
<font size="2">RE: [OSGeo-Discuss] WMS Performance Shootout presentation/results</font></td></tr>
</table>
<table border="0" cellspacing="0" cellpadding="0">
<tr valign="top"><td width="58"><img width="1" height="1" src="cid:3__=0ABBFCCEDFF1B8F48f9e8a93df938690@fws.gov" border="0" alt=""></td><td width="336"><img width="1" height="1" src="cid:3__=0ABBFCCEDFF1B8F48f9e8a93df938690@fws.gov" border="0" alt=""></td></tr>
</table>
</td></tr>
</table>
<br>
<font face="Times New Roman">Great to see the shootout results.</font><br>
<font face="Times New Roman"> </font><br>
<font face="Times New Roman">Also interesting to see the Amazon RDS announcement (MySQL based) with possibility of using quadruple extra large EC2 instances: db.m2.4xlarge - 68 GB of RAM </font><br>
<a href="http://aws.typepad.com/aws/2009/10/introducing-rds-the-amazon-relational-database-service-.html"><u><font color="#0000FF" face="Times New Roman">http://aws.typepad.com/aws/2009/10/introducing-rds-the-amazon-relational-database-service-.html</font></u></a><br>
<a href="http://aws.typepad.com/aws/2009/10/two-new-ec2-instance-types-additional-memory.html"><u><font color="#0000FF" face="Times New Roman">http://aws.typepad.com/aws/2009/10/two-new-ec2-instance-types-additional-memory.html</font></u></a><br>
<font face="Times New Roman"> </font><br>
<font face="Times New Roman">Maybe next shootout the DB layer could look at Amazon RDS(mySQL) and PostgreSQL/PostGIS using a quadruple extra large instance 68Gb RAM. </font><br>
<font face="Times New Roman"> </font><br>
<font face="Times New Roman">After reading Todd Hoff’s blog I’d be curious to see if PostGIS could be configured to make use of large memory capacities and how it affects performance:</font><br>
<a href="http://highscalability.com/are-cloud-based-memory-architectures-next-big-thing"><u><font color="#0000FF" face="Times New Roman">http://highscalability.com/are-cloud-based-memory-architectures-next-big-thing</font></u></a><br>
<font face="Times New Roman"> </font><br>
<font face="Times New Roman">Thanks</font><br>
<font face="Times New Roman">Randy</font><br>
<font face="Times New Roman"> </font><br>
<font face="Times New Roman"> </font><br>
<font face="Times New Roman"> </font><br>
<font face="Times New Roman"> </font><br>
<b><font face="Times New Roman">From:</font></b><font face="Times New Roman"> discuss-bounces@lists.osgeo.org [<a href="mailto:discuss-bounces@lists.osgeo.org">mailto:discuss-bounces@lists.osgeo.org</a>] </font><b><font face="Times New Roman">On Behalf Of </font></b><font face="Times New Roman">Craig Miller</font><b><font face="Times New Roman"><br>
Sent:</font></b><font face="Times New Roman"> Friday, October 23, 2009 8:38 PM</font><b><font face="Times New Roman"><br>
To:</font></b><font face="Times New Roman"> 'OSGeo Discussions'</font><b><font face="Times New Roman"><br>
Subject:</font></b><font face="Times New Roman"> RE: [OSGeo-Discuss] WMS Performance Shootout presentation/results</font><br>
<font size="4" face="Times New Roman"> </font><br>
<font face="Times New Roman">I agree wholeheartedly. It looks like the bottleneck was the database. I’ve been privy to some MapServer tests done by testing teams over several months and the result there was always deploying the data with long update cycles to the middle tier disks instead of using the database. Only then could the performance of the actual map servers be evaluated. Performance shootouts/testing take time to do correctly as each run teaches you more and more about how your deployment architecture affects the results.</font><br>
<font face="Times New Roman"> </font><br>
<font face="Times New Roman">Craig</font><br>
<font face="Times New Roman">Geospatial Software Engineer</font><br>
<a href="http://spatialminds.com/"><u><font color="#0000FF" face="Times New Roman">Spatial Minds, LLC</font></u></a><br>
<font face="Times New Roman"> </font><br>
<b><font face="Times New Roman">From:</font></b><font face="Times New Roman"> discuss-bounces@lists.osgeo.org [<a href="mailto:discuss-bounces@lists.osgeo.org">mailto:discuss-bounces@lists.osgeo.org</a>] </font><b><font face="Times New Roman">On Behalf Of </font></b><font face="Times New Roman">antti roppola</font><b><font face="Times New Roman"><br>
Sent:</font></b><font face="Times New Roman"> Friday, October 23, 2009 7:34 PM</font><b><font face="Times New Roman"><br>
To:</font></b><font face="Times New Roman"> OSGeo Discussions</font><b><font face="Times New Roman"><br>
Subject:</font></b><font face="Times New Roman"> Re: [OSGeo-Discuss] WMS Performance Shootout presentation/results</font><br>
<font size="4" face="Times New Roman"> </font><br>
<font size="4" face="Times New Roman">It was really interesting. The very close results suggests to me that the bottlenecks were external to the WMS and more related to external limitations like the ability to supply things like I/O. It would be interesting to have profiling data on where the response time was spent. For Mapserver it'd be a simple case of running Valgrinf and KCacheGrind:<br>
</font><u><font size="4" color="#0000FF" face="Times New Roman"><br>
</font></u><a href="http://kcachegrind.sourceforge.net/cgi-bin/show.cgi/KcacheGrindIndex"><u><font size="4" color="#0000FF" face="Times New Roman">http://kcachegrind.sourceforge.net/cgi-bin/show.cgi/KcacheGrindIndex</font></u></a><font size="4" face="Times New Roman"><br>
<br>
Case point. We had an in house app for crunching big raster and KCacheGrind showed us that an external library was the biggest bottleneck.<br>
<br>
A.</font><br>
<font size="4" face="Times New Roman">On Sat, Oct 24, 2009 at 10:39 AM, Jeff McKenna <</font><a href="mailto:jmckenna@gatewaygeomatics.com"><u><font size="4" color="#0000FF" face="Times New Roman">jmckenna@gatewaygeomatics.com</font></u></a><font size="4" face="Times New Roman">> wrote:</font><br>
<font size="4" face="Times New Roman">For those that did not make it to Sydney, here is the WMS Performance<br>
Shootout presentation with results (GeoServer vs MapServer):<br>
</font><u><font size="4" color="#0000FF" face="Times New Roman"><br>
</font></u><a href="http://www.slideshare.net/gatewaygeomatics.com/wms-performance-shootout" target="_blank"><u><font size="4" color="#0000FF" face="Times New Roman">http://www.slideshare.net/gatewaygeomatics.com/wms-performance-shootout</font></u></a><font size="4" face="Times New Roman"><br>
<br>
MapServer: power users who manage MapServer sites with high loads/map draws should<br>
take note of the results of MapServer CGI vs MapServer FastCGI, even in<br>
the case of Shapefiles and Rasters (yes, quite surprising).<br>
<br>
All: a lot of credit should go to Andrea Aime from GeoServer who worked very hard in bringing the MapServer team up to speed to learn the testing process. It was a great experience and we're already looking forward to next year.<br>
<br>
-jeff<br>
<br>
<br>
-- <br>
Jeff McKenna<br>
FOSS4G Consulting and Training Services</font><u><font size="4" color="#0000FF" face="Times New Roman"><br>
</font></u><a href="http://www.gatewaygeomatics.com/" target="_blank"><u><font size="4" color="#0000FF" face="Times New Roman">http://www.gatewaygeomatics.com/</font></u></a><font size="4" face="Times New Roman"><br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
_______________________________________________<br>
mapserver-users mailing list</font><u><font size="4" color="#0000FF" face="Times New Roman"><br>
</font></u><a href="mailto:mapserver-users@lists.osgeo.org" target="_blank"><u><font size="4" color="#0000FF" face="Times New Roman">mapserver-users@lists.osgeo.org</font></u></a><u><font size="4" color="#0000FF" face="Times New Roman"><br>
</font></u><a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank"><u><font size="4" color="#0000FF" face="Times New Roman">http://lists.osgeo.org/mailman/listinfo/mapserver-users</font></u></a><font size="4" face="Times New Roman"><br>
<br>
<br>
-- <br>
Jeff McKenna<br>
FOSS4G Consulting and Training Services</font><u><font size="4" color="#0000FF" face="Times New Roman"><br>
</font></u><a href="http://www.gatewaygeomatics.com/" target="_blank"><u><font size="4" color="#0000FF" face="Times New Roman">http://www.gatewaygeomatics.com/</font></u></a><font size="4" face="Times New Roman"><br>
<br>
<br>
_______________________________________________<br>
Discuss mailing list</font><u><font size="4" color="#0000FF" face="Times New Roman"><br>
</font></u><a href="mailto:Discuss@lists.osgeo.org" target="_blank"><u><font size="4" color="#0000FF" face="Times New Roman">Discuss@lists.osgeo.org</font></u></a><u><font size="4" color="#0000FF" face="Times New Roman"><br>
</font></u><a href="http://lists.osgeo.org/mailman/listinfo/discuss" target="_blank"><u><font size="4" color="#0000FF" face="Times New Roman">http://lists.osgeo.org/mailman/listinfo/discuss</font></u></a><br>
<font size="4" face="Times New Roman"> </font><tt>_______________________________________________<br>
Discuss mailing list<br>
Discuss@lists.osgeo.org<br>
</tt><tt><a href="http://lists.osgeo.org/mailman/listinfo/discuss">http://lists.osgeo.org/mailman/listinfo/discuss</a></tt><tt><br>
</tt><br>
</body></html>