From owner-freebsd-fs@FreeBSD.ORG  Mon Jul  8 12:41:01 2013
Return-Path: <owner-freebsd-fs@FreeBSD.ORG>
Delivered-To: freebsd-fs@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org
 [IPv6:2001:1900:2254:206a::19:1])
 by hub.freebsd.org (Postfix) with ESMTP id 1516EDFA;
 Mon,  8 Jul 2013 12:41:01 +0000 (UTC)
 (envelope-from artem.naluzhnyy@gmail.com)
Received: from mail-wg0-x230.google.com (mail-wg0-x230.google.com
 [IPv6:2a00:1450:400c:c00::230])
 by mx1.freebsd.org (Postfix) with ESMTP id 80E3F1E7B;
 Mon,  8 Jul 2013 12:41:00 +0000 (UTC)
Received: by mail-wg0-f48.google.com with SMTP id f11so3647706wgh.15
 for <multiple recipients>; Mon, 08 Jul 2013 05:40:59 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
 h=mime-version:from:date:message-id:subject:to:content-type;
 bh=3C6s6nuonag5V+OfmlZYnUOWv/ddTgytAS0EZmFz7Ng=;
 b=xI2Frg0EwzlW+AwT2r58d1GgN1/B6d9TogCY59nNJaYDz0fpr6KL4ORmYCDICpRyiy
 3G4t1TqdCFONwbjS4ZgJ2eXYkoUJ+e3bmcMeehntHhX0W9NFcSVUzM+x2WYhQgRLp9Or
 Rm3NL3D/vJvttSUtQyo2Wy49g3NtM80jVa5dWhBVB1+ASYrCK01kN+74vfzw2S3EbOSp
 +ikoNV1EMQxHPvcpPQUmh95i+2pOKIhFulmRrRfbPA/ElZNj9HMvNn62VOSzlfYUmF7c
 Jx+ao0LtWTJvK+kiHL6TG6pUeq/5X4oFASuqgZyefzcE9sz4qqTFDIV0O9gWOZb7qs61
 8LRA==
X-Received: by 10.180.211.171 with SMTP id nd11mr11512989wic.17.1373287259569; 
 Mon, 08 Jul 2013 05:40:59 -0700 (PDT)
MIME-Version: 1.0
Received: by 10.217.123.138 with HTTP; Mon, 8 Jul 2013 05:40:19 -0700 (PDT)
From: Artem Naluzhnyy <artem.naluzhnyy@gmail.com>
Date: Mon, 8 Jul 2013 15:40:19 +0300
Message-ID: <CAEGTrdKZetiwczu=39433KtX3Px7vgsJxzFBB-_AtAgsKoYkdw@mail.gmail.com>
Subject: RAID10 stripe size and PostgreSQL performance
To: freebsd-database@freebsd.org, freebsd-fs@freebsd.org
Content-Type: text/plain; charset=UTF-8
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 12:41:01 -0000

Hi,

I'm benchmarking PostgreSQL using different RAID10 stripe size values
for a new server. Tried bonnie++ and pgbench on two stripe size
configurations:

  * 32 KB (a half of current UFS bsize) - 254 pgbench tps
  * 1 MB (max supported by the RAID controller) - 626 pgbench tps

See OS/hardware configuration, benchmark methodology and raw results
here - http://pastebin.com/F8uZEZdm

Is this expected behavior with more than twice higher pgbench tps on
1MB stripe size?

Are there any RAID stripe size recommendations for better PostgreSQL
performance? (I can not change the FS type, standard PG block size
etc. - they are locked by vendor in this commercial FreeBSD
distribution)

-- 
Artem Naluzhnyy