From owner-freebsd-fs@FreeBSD.ORG Mon Jul 8 15:17:10 2013 Return-Path: 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 ; 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 ; Mon, 8 Jul 2013 15:17:09 +0000 (UTC) Received: from list by plane.gmane.org with local (Exim 4.69) (envelope-from ) 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 ; 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 ; Mon, 08 Jul 2013 17:17:02 +0200 X-Injected-Via-Gmane: http://gmane.org/ To: freebsd-fs@freebsd.org From: Ivan Voras Subject: Re: RAID10 stripe size and PostgreSQL performance Date: Mon, 08 Jul 2013 17:16:45 +0200 Lines: 50 Message-ID: References: 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: 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 List-Unsubscribe: , List-Archive: List-Post: List-Help: List-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--