From owner-freebsd-fs@FreeBSD.ORG  Mon Jul  8 15:17:10 2013
Return-Path: <owner-freebsd-fs@FreeBSD.ORG>
Delivered-To: freebsd-fs@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [8.8.178.115])
 by hub.freebsd.org (Postfix) with ESMTP id 8623AB86
 for <freebsd-fs@freebsd.org>; Mon,  8 Jul 2013 15:17:10 +0000 (UTC)
 (envelope-from freebsd-fs@m.gmane.org)
Received: from plane.gmane.org (plane.gmane.org [80.91.229.3])
 by mx1.freebsd.org (Postfix) with ESMTP id 44CD31838
 for <freebsd-fs@freebsd.org>; Mon,  8 Jul 2013 15:17:09 +0000 (UTC)
Received: from list by plane.gmane.org with local (Exim 4.69)
 (envelope-from <freebsd-fs@m.gmane.org>) id 1UwDBW-000125-Dt
 for freebsd-fs@freebsd.org; Mon, 08 Jul 2013 17:17:02 +0200
Received: from lara.cc.fer.hr ([161.53.72.113])
 by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
 id 1AlnuQ-0007hv-00
 for <freebsd-fs@freebsd.org>; Mon, 08 Jul 2013 17:17:02 +0200
Received: from ivoras by lara.cc.fer.hr with local (Gmexim 0.1 (Debian))
 id 1AlnuQ-0007hv-00
 for <freebsd-fs@freebsd.org>; Mon, 08 Jul 2013 17:17:02 +0200
X-Injected-Via-Gmane: http://gmane.org/
To: freebsd-fs@freebsd.org
From: Ivan Voras <ivoras@freebsd.org>
Subject: Re: RAID10 stripe size and PostgreSQL performance
Date: Mon, 08 Jul 2013 17:16:45 +0200
Lines: 50
Message-ID: <krel4o$q96$1@ger.gmane.org>
References: <CAEGTrdKZetiwczu=39433KtX3Px7vgsJxzFBB-_AtAgsKoYkdw@mail.gmail.com>
Mime-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="----enig2UBCEUFKHBCWAHTMQXKDM"
X-Complaints-To: usenet@ger.gmane.org
X-Gmane-NNTP-Posting-Host: lara.cc.fer.hr
User-Agent: Mozilla/5.0 (X11; FreeBSD amd64;
 rv:17.0) Gecko/20130322 Thunderbird/17.0.4
In-Reply-To: <CAEGTrdKZetiwczu=39433KtX3Px7vgsJxzFBB-_AtAgsKoYkdw@mail.gmail.com>
X-Enigmail-Version: 1.5.1
Cc: freebsd-database@freebsd.org
X-BeenThere: freebsd-fs@freebsd.org
X-Mailman-Version: 2.1.14
Precedence: list
List-Id: Filesystems <freebsd-fs.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/options/freebsd-fs>,
 <mailto:freebsd-fs-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-fs>
List-Post: <mailto:freebsd-fs@freebsd.org>
List-Help: <mailto:freebsd-fs-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-fs>,
 <mailto:freebsd-fs-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Mon, 08 Jul 2013 15:17:10 -0000

This is an OpenPGP/MIME signed message (RFC 4880 and 3156)
------enig2UBCEUFKHBCWAHTMQXKDM
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

On 08/07/2013 14:40, Artem Naluzhnyy wrote:
> Hi,
>=20
> I'm benchmarking PostgreSQL using different RAID10 stripe size values
> for a new server. Tried bonnie++ and pgbench on two stripe size
> configurations:
>=20
>   * 32 KB (a half of current UFS bsize) - 254 pgbench tps
>   * 1 MB (max supported by the RAID controller) - 626 pgbench tps
>=20
> See OS/hardware configuration, benchmark methodology and raw results
> here - http://pastebin.com/F8uZEZdm
>=20
> Is this expected behavior with more than twice higher pgbench tps on
> 1MB stripe size?

No, it is not.

For start, can you please repeat your benchmarks but with restarting the
PostgreSQL server between each pgbench run?

Also, you should make sure that the database is located on the same
location on the disk platters by e.g. creating a small partition which
is about 150% larger than your pgbench database (and your pgbench
database should be at least 2x larger than your RAM, if you are going to
benchmark IO and not memory caches), which is located at the same
position (byte offset) in your RAID10 volume.



------enig2UBCEUFKHBCWAHTMQXKDM
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.19 (FreeBSD)
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iEYEARECAAYFAlHa194ACgkQ/QjVBj3/HSzcsACgn/Z2oEbEzOYTUc+jxH8ZY90s
y3AAoJel6Gebm0Wi0ScGFpMXrdo9PKv1
=Q4jH
-----END PGP SIGNATURE-----

------enig2UBCEUFKHBCWAHTMQXKDM--