Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Ye5eB-0008Qp-GA for pgsql-performance@arkaria.postgresql.org; Fri, 03 Apr 2015 17:44:47 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Ye5eA-0002vy-SR for pgsql-performance@arkaria.postgresql.org; Fri, 03 Apr 2015 17:44:46 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1Ye5e9-0002vp-97 for pgsql-performance@postgresql.org; Fri, 03 Apr 2015 17:44:45 +0000 Received: from mail-by2on0766.outbound.protection.outlook.com ([2a01:111:f400:fc0c::766] helo=na01-by2-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Ye5e3-00077q-Hi for pgsql-performance@postgresql.org; Fri, 03 Apr 2015 17:44:42 +0000 Received: from BN1PR05MB009.namprd05.prod.outlook.com (10.255.202.141) by BN1PR05MB009.namprd05.prod.outlook.com (10.255.202.141) with Microsoft SMTP Server (TLS) id 15.1.125.19; Fri, 3 Apr 2015 17:44:30 +0000 Received: from BN1PR05MB009.namprd05.prod.outlook.com ([169.254.15.202]) by BN1PR05MB009.namprd05.prod.outlook.com ([169.254.15.202]) with mapi id 15.01.0125.002; Fri, 3 Apr 2015 17:44:30 +0000 From: Mel Llaguno To: =?iso-8859-2?Q?Przemys=B3aw_De=E6?= CC: Josh Berkus , "pgsql-performance@postgresql.org" Subject: Re: Some performance testing? Thread-Topic: [PERFORM] Some performance testing? Thread-Index: AQHQa+y0oLex6B2bWESYrFzIt6Alq502qcWAgAEsq4CAAAa/AIADtnm2 Date: Fri, 3 Apr 2015 17:44:30 +0000 Message-ID: <1428083069862.19162@coverity.com> References: <551AFB01.50309@agliodbs.com> , In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [184.70.198.10] authentication-results: agliodbs.com; dkim=none (message not signed) header.d=none; x-microsoft-antispam: UriScan:;BCL:0;PCL:0;RULEID:;SRVR:BN1PR05MB009; x-microsoft-antispam-prvs: x-forefront-antispam-report: BMV:1; SFV:NSPM; SFS:(10019020)(377424004)(164054003)(24454002)(51704005)(377454003)(479174004)(36756003)(16799955002)(16601075003)(117636001)(66066001)(16236675004)(19617315012)(18206015028)(15188155005)(62966003)(77156002)(87936001)(54356999)(19625215002)(46102003)(76176999)(50986999)(40100003)(92566002)(106116001)(19627405001)(2950100001)(99286002)(110136001)(19580395003)(122556002)(2656002)(102836002)(19580405001)(15975445007)(2900100001)(86362001); DIR:OUT; SFP:1102; SCL:1; SRVR:BN1PR05MB009; H:BN1PR05MB009.namprd05.prod.outlook.com; FPR:; SPF:None; MLV:sfv; LANG:en; x-exchange-antispam-report-test: UriScan:; x-exchange-antispam-report-cfa-test: BCL:0; PCL:0; RULEID:(601004)(5005006)(5002010); SRVR:BN1PR05MB009; BCL:0; PCL:0; RULEID:; SRVR:BN1PR05MB009; x-forefront-prvs: 05352A48BE Content-Type: multipart/alternative; boundary="_000_142808306986219162coveritycom_" MIME-Version: 1.0 X-OriginatorOrg: coverity.com X-MS-Exchange-CrossTenant-originalarrivaltime: 03 Apr 2015 17:44:30.1404 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 809a746c-a8df-4f37-86a4-bd3974a40f1e X-MS-Exchange-Transport-CrossTenantHeadersStamped: BN1PR05MB009 X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org --_000_142808306986219162coveritycom_ Content-Type: text/plain; charset="iso-8859-2" Content-Transfer-Encoding: quoted-printable Although the results only focus on SATA2 HDD, these may be useful for a com= parison of ext4 vs. xfs : http://www.fuzzy.cz/bench/compare-pgbench.php?typ= e[]=3Dbtrfs-datacow-barrier:1&type[]=3Dbtrfs-datacow-nobarrier:1&type[]=3Db= trfs-nodatacow-barrier:1&type[]=3Dbtrfs-nodatacow-nobarrier:1&type[]=3Dext4= -writeback-barrier:1&type[]=3Dext4-writeback-nobarrier:1&type[]=3Dxfs-barri= er:1&type[]=3Dxfs-nobarrier:1? M. ________________________________ From: Przemys=B3aw De=E6 Sent: Wednesday, April 01, 2015 3:02 AM To: Mel Llaguno Cc: Josh Berkus; pgsql-performance@postgresql.org Subject: Re: [PERFORM] Some performance testing? Maybe you will find time to benchamark xfs vs ext4 (with and without journa= ling enabled on ext4). Nice comparison also could be rhel 6.5 with its newest kernel 2.6.32-X vs R= HEL 7.0 and kernel 3.10. I was looking for some guidance what to choose and there is very poor infor= mation about such things. [https://ssl.gstatic.com/ui/v1/icons/mail/images/cleardot.gif] -- Przemys=B3aw De=E6 Senior Solutions Architect Linux Polska Sp. z o.o 2015-04-01 10:37 GMT+02:00 Przemys=B3aw De=E6 >: Maybe you will find time to benchamark xfs vs ext4 (with and without journa= ling enabled on ext4). Nice comparison also could be rhel 6.5 with its newest kernel 2.6.32-X vs R= HEL 7.0 and kernel 3.10. I was looking for some guidance what to choose and there is very poor infor= mation about such things. -- Przemys=B3aw De=E6 Senior Solutions Architect Linux Polska Sp. z o.o 2015-03-31 22:41 GMT+02:00 Mel Llaguno >: 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=3Dtempfile of=3D/dev/null bs= =3D1M count=3D1024 && echo 3 > /proc/sys/vm/drop_caches; dd if=3Dtempfileof=3D/dev/null bs=3D1M count=3D1024 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 * Twit= ter: @coverity Coverity by Synopsys On 3/31/15, 1:52 PM, "Josh Berkus" > 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@postgresql.org<= mailto:pgsql-performance@postgresql.org>) >To make changes to your subscription: >http://www.postgresql.org/mailpref/pgsql-performance -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance --_000_142808306986219162coveritycom_ Content-Type: text/html; charset="iso-8859-2" Content-Transfer-Encoding: quoted-printable

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[]= =3Dbtrfs-datacow-barrier:1&type[]=3Dbtrfs-datacow-nobarrier:1&type[= ]=3Dbtrfs-nodatacow-barrier:1&type[]=3Dbtrfs-nodatacow-nobarrier:1&= type[]=3Dext4-writeback-barrier:1&type[]=3Dext4-writeback-nobarrier:1&a= mp;type[]=3Dxfs-barrier:1&type[]=3Dxfs-nobarrier:1​


M.

From: Przemys=B3aw De=E6 &l= t;przemyslaw.dec@linuxpolska.pl>
Sent: Wednesday, April 01, 2015 3:02 AM
To: Mel Llaguno
Cc: Josh Berkus; pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Some performance testing?
 
Maybe you will find time to benchamark xfs vs ext4 (with and without j= ournaling enabled on ext4).

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

I was looking for some guidance what to choose and there is very poor infor= mation about such things.
<= span class=3D"">
--
Przemys=B3aw De=E6
Senior Solutions Architect
Linux Polska Sp. z o.o
2015-04-01 10:37 GMT+02:00 Przemys=B3aw De= =E6 <prze= myslaw.dec@linuxpolska.pl>:
Maybe you will find time to benchamark xfs vs ext4 (with and without j= ournaling enabled on ext4).

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

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

--
Przemys=B3aw De=E6
Senior Solutions Architect
Linux Polska Sp. z o.o


2015-03-31 22:41 GMT+02:00 Mel Llaguno <mllaguno@coverity.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=3Dtempfile of=3D/dev/null bs= =3D1M
count=3D1024 && echo 3 > /proc/sys/vm/drop_caches; dd
if=3Dtempfileof=3D/dev/null bs=3D1M count=3D1024
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 type= s 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 Digita= l
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.cover= ity.com/> • Twitter: @coverity
Coverity by Synopsys


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



--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance



--_000_142808306986219162coveritycom_--