From owner-freebsd-fs@FreeBSD.ORG Wed Nov 28 08:36:11 2012 Return-Path: Delivered-To: freebsd-fs@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id E1009171 for ; Wed, 28 Nov 2012 08:36:11 +0000 (UTC) (envelope-from metindoslu@gmail.com) Received: from mail-qc0-f182.google.com (mail-qc0-f182.google.com [209.85.216.182]) by mx1.freebsd.org (Postfix) with ESMTP id 98F1D8FC08 for ; Wed, 28 Nov 2012 08:36:11 +0000 (UTC) Received: by mail-qc0-f182.google.com with SMTP id k19so12056631qcs.13 for ; Wed, 28 Nov 2012 00:36:10 -0800 (PST) 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 :content-transfer-encoding; bh=vVPdE3+rUPTF5V3gNXOkhxHgSraWGqZezEHe7XWwUj0=; b=zSCfk8eNeXKy1fXgjExGJ192IKmUhXqjDQHe74KPDlFs+9SR2th8zr2oy0eIwW1M5L lSMGixoeKI3ETLpvKiv+DZQopuwVajxYFmgbMrvmg+OdpxScA0IaBNnXyIVkcljHwflC HcUpMAiZHv2r4UpDA9wOi1KC7eMWcniPem0Lh++alskveT9W8sAFFC8yGtILALiSl4Ut uQ1jsm3wbl9OLTdF8LusTooxpoz6nU5jkzTURYRXgkmc9M6TYSNje3OmZrvQhmaZ1vOm MNDQPz/FpuklbOIRlsbl9yCNzr8tqBTxNUfVN02hV7x8H0t/MCecxUcCgI6CauO42ce9 Vmyg== Received: by 10.49.75.226 with SMTP id f2mr14016114qew.43.1354091770060; Wed, 28 Nov 2012 00:36:10 -0800 (PST) MIME-Version: 1.0 Received: by 10.49.35.242 with HTTP; Wed, 28 Nov 2012 00:35:49 -0800 (PST) From: =?UTF-8?B?TWV0aW4gRMO2xZ9sw7w=?= Date: Wed, 28 Nov 2012 10:35:49 +0200 Message-ID: Subject: Performance Difference on UFS and ZFS To: freebsd-fs@freebsd.org Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable 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: Wed, 28 Nov 2012 08:36:11 -0000 Hi - I installed PostgreSQL 9.1.6 on FreeBSD 9.0-RELEASE, and compared ZFS to UFS. I also made sure all data easily fit into memory, ran some sequential scan queries on the database. Query run times on UFS were 100-200% slower than those of ZFS. This was intriguing as all data came from memory. What could be causing such a large performance difference? Thanks, Metin D=C3=B6=C5=9Fl=C3=BC