Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 53DD263336F for ; Fri, 4 Jun 2010 09:27:43 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 45928-04 for ; Fri, 4 Jun 2010 12:27:34 +0000 (UTC) X-Greylist: delayed 00:09:55.862961 by SQLgrey-1.7.6 Received: from mtu.net (mtu.net [204.11.35.17]) by mail.postgresql.org (Postfix) with ESMTP id 27C93632EB7 for ; Fri, 4 Jun 2010 09:27:36 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by mtu.net (Postfix) with ESMTP id DA6C4143E504 for ; Fri, 4 Jun 2010 08:17:37 -0400 (EDT) X-Virus-Scanned: Debian amavisd-new at mtu.net Received: from mtu.net ([127.0.0.1]) by localhost (mtu.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id GvVZv9Sw3xz6 for ; Fri, 4 Jun 2010 08:17:36 -0400 (EDT) Received: from [192.168.42.2] (jon [76.17.225.95]) (Authenticated sender: jpschewe) by mtu.net (Postfix) with ESMTPSA id 4C661143E503 for ; Fri, 4 Jun 2010 08:17:36 -0400 (EDT) Message-ID: <4C08EEDF.7090403@mtu.net> Date: Fri, 04 Jun 2010 07:17:35 -0500 From: Jon Schewe User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.1.9) Gecko/20100317 SUSE/3.0.4-1.1.1 Lightning/1.0b1 Thunderbird/3.0.4 MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: How filesystems matter with PostgreSQL X-Enigmail-Version: 1.0.1 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.011 tagged_above=-10 required=5 tests=BAYES_40=-0.001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201006/77 X-Sequence-Number: 38933 Some interesting data about different filesystems I tried with PostgreSQL and how it came out. I have an application that is backed in postgres using Java JDBC to access it. The tests were all done on an opensuse 11.2 64-bit machine, on the same hard drive (just ran mkfs between each test) on the same input with the same code base. All filesystems were created with the default options. XFS (logbufs=8): ~4 hours to finish ext4: ~1 hour 50 minutes to finish ext3: 15 minutes to finish ext3 on LVM: 15 minutes to finish -- Jon Schewe | http://mtu.net/~jpschewe If you see an attachment named signature.asc, this is my digital signature. See http://www.gnupg.org for more information.