Re: Some performance testing?

Although the results only focus on SATA2 HDD, these may be useful for a comparison of ext4 vs. xfs : http://www.fuzzy.cz/bench/compare-pgbench.php?type[]=btrfs-datacow-barrier:1&type[]=btrfs-datacow-nobarrier:1&type[]=btrfs-nodatacow-barrier:1&type[]=btrfs-nodatacow-nobarrier:1&type[]=ext4-writeback-barrier:1&type[]=ext4-writeback-nobarrier:1&type[]=xfs-barrier:1&type[]=xfs-nobarrier:1?

M.

________________________________
From: Przemysław Deć <przemyslaw(dot)dec(at)linuxpolska(dot)pl>
Sent: Wednesday, April 01, 2015 3:02 AM
To: Mel Llaguno
Cc: Josh Berkus; pgsql-performance(at)postgresql(dot)org
Subject: Re: [PERFORM] Some performance testing?

Maybe you will find time to benchamark xfs vs ext4 (with and without journaling enabled on ext4).

Nice comparison also could be rhel 6.5 with its newest kernel 2.6.32-X vs RHEL 7.0 and kernel 3.10.

I was looking for some guidance what to choose and there is very poor information about such things.
[https://ssl.gstatic.com/ui/v1/icons/mail/images/cleardot.gif]
--
Przemysław Deć
Senior Solutions Architect
Linux Polska Sp. z o.o

2015-04-01 10:37 GMT+02:00 Przemysław Deć <przemyslaw(dot)dec(at)linuxpolska(dot)pl<mailto:przemyslaw(dot)dec(at)linuxpolska(dot)pl>>:
Maybe you will find time to benchamark xfs vs ext4 (with and without journaling enabled on ext4).

Nice comparison also could be rhel 6.5 with its newest kernel 2.6.32-X vs RHEL 7.0 and kernel 3.10.

I was looking for some guidance what to choose and there is very poor information about such things.

--
Przemysław Deć
Senior Solutions Architect
Linux Polska Sp. z o.o

2015-03-31 22:41 GMT+02:00 Mel Llaguno <mllaguno(at)coverity(dot)com<mailto:mllaguno(at)coverity(dot)com>>:
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> <http://www.coverity.com/> * Twitter: @coverity
Coverity by Synopsys

On 3/31/15, 1:52 PM, "Josh Berkus" <josh(at)agliodbs(dot)com<mailto:josh(at)agliodbs(dot)com>> 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(at)postgresql(dot)org<mailto:pgsql-performance(at)postgresql(dot)org>)
>To make changes to your subscription:
>http://www.postgresql.org/mailpref/pgsql-performance

--
Sent via pgsql-performance mailing list (pgsql-performance(at)postgresql(dot)org<mailto:pgsql-performance(at)postgresql(dot)org>)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance