http://magazine.redhat.com/2007/12/12/tip-from-an-rhce-memory-storage-on-postgresql/
Doug Newcomb USFWS Raleigh, NC 919-856-4520 ext. 14 doug_newc...@fws.gov --------------------------------------------------------------------------------------------------------- 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. "Randy George" <rkgeo...@cadmaps .com> To Sent by: "'OSGeo Discussions'" discuss-boun...@l <discuss@lists.osgeo.org> ists.osgeo.org cc Subject 10/28/2009 01:42 RE: [OSGeo-Discuss] WMS Performance PM Shootout presentation/results Please respond to rkgeo...@cadmaps. com; Please respond to OSGeo Discussions <disc...@lists.os geo.org> Great to see the shootout results. 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 http://aws.typepad.com/aws/2009/10/introducing-rds-the-amazon-relational-database-service-.html http://aws.typepad.com/aws/2009/10/two-new-ec2-instance-types-additional-memory.html Maybe next shootout the DB layer could look at Amazon RDS(mySQL) and PostgreSQL/PostGIS using a quadruple extra large instance 68Gb RAM. 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: http://highscalability.com/are-cloud-based-memory-architectures-next-big-thing Thanks Randy From: discuss-boun...@lists.osgeo.org [mailto:discuss-boun...@lists.osgeo.org] On Behalf Of Craig Miller Sent: Friday, October 23, 2009 8:38 PM To: 'OSGeo Discussions' Subject: RE: [OSGeo-Discuss] WMS Performance Shootout presentation/results 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. Craig Geospatial Software Engineer Spatial Minds, LLC From: discuss-boun...@lists.osgeo.org [mailto:discuss-boun...@lists.osgeo.org] On Behalf Of antti roppola Sent: Friday, October 23, 2009 7:34 PM To: OSGeo Discussions Subject: Re: [OSGeo-Discuss] WMS Performance Shootout presentation/results 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: http://kcachegrind.sourceforge.net/cgi-bin/show.cgi/KcacheGrindIndex Case point. We had an in house app for crunching big raster and KCacheGrind showed us that an external library was the biggest bottleneck. A. On Sat, Oct 24, 2009 at 10:39 AM, Jeff McKenna < jmcke...@gatewaygeomatics.com> wrote: For those that did not make it to Sydney, here is the WMS Performance Shootout presentation with results (GeoServer vs MapServer): http://www.slideshare.net/gatewaygeomatics.com/wms-performance-shootout MapServer: power users who manage MapServer sites with high loads/map draws should take note of the results of MapServer CGI vs MapServer FastCGI, even in the case of Shapefiles and Rasters (yes, quite surprising). 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. -jeff -- Jeff McKenna FOSS4G Consulting and Training Services http://www.gatewaygeomatics.com/ _______________________________________________ mapserver-users mailing list mapserver-us...@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users -- Jeff McKenna FOSS4G Consulting and Training Services http://www.gatewaygeomatics.com/ _______________________________________________ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss _______________________________________________ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss
<<inline: graycol.gif>>
<<inline: pic26418.gif>>
<<inline: ecblank.gif>>
_______________________________________________ Discuss mailing list Discuss@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/discuss