It would be interesting to get raw performance benchmarks in addition to PG specific benchmarks. I’ve been measuring raw I/O performance of a few of our systems and run the following tests as well: 1. 10 runs of bonnie++ 2. 5 runs of hdparm -Tt 3. Using a temp file created on the SSD, dd if=tempfile of=/dev/null bs=1M count=1024 && echo 3 > /proc/sys/vm/drop_caches; dd if=tempfileof=/dev/null bs=1M count=1024 4. Using phoronix benchmarks -> stream / ramspeed / compress-7zip I was curious to measure the magnitude of difference between HDD -> SSD. I would expect significant differences between SSD -> PCI-E Flash. I’ve included some metrics from some previous runs vs. different types of SSDs (OWC Mercury Extreme 6G which is our standard SSD, an Intel S3700 SSD, a Samsung SSD 840 PRO) vs. some standard HDD from Western Digital and HGST. I put in a req for a 960Gb Mercury Excelsior PCI-E SSD which hasn’t yet materialized ... Thanks, M. Mel Llaguno • Staff Engineer – Team Lead Office: +1.403.264.9717 x310 www.coverity.com <http://www.coverity.com/> • Twitter: @coverity Coverity by Synopsys On 3/31/15, 1:52 PM, "Josh Berkus" <josh@xxxxxxxxxxxx> wrote: >All, > >I currently have access to a matched pair of 20-core, 128GB RAM servers >with SSD-PCI storage, for about 2 weeks before they go into production. > Are there any performance tests people would like to see me run on >these? Otherwise, I'll just do some pgbench and DVDStore. > >-- >Josh Berkus >PostgreSQL Experts Inc. >http://pgexperts.com > > >-- >Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) >To make changes to your subscription: >http://www.postgresql.org/mailpref/pgsql-performance
Attachment:
System Benchmarks.xlsx
Description: System Benchmarks.xlsx
-- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
