Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 5D2776335E0 for ; Fri, 4 Jun 2010 09:39:27 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 14822-09 for ; Fri, 4 Jun 2010 12:39:20 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtpq3.tb.mail.iss.as9143.net (smtpq3.tb.mail.iss.as9143.net [212.54.42.166]) by mail.postgresql.org (Postfix) with ESMTP id 1003F6335D4 for ; Fri, 4 Jun 2010 09:39:19 -0300 (ADT) Received: from [212.54.42.139] (helo=smtp8.tb.mail.iss.as9143.net) by smtpq3.tb.mail.iss.as9143.net with esmtp (Exim 4.69) (envelope-from ) id 1OKWBB-0008It-QF for pgsql-performance@postgresql.org; Fri, 04 Jun 2010 14:39:17 +0200 Received: from 5353294f.cable.casema.nl ([83.83.41.79] helo=data.antarean.org) by smtp8.tb.mail.iss.as9143.net with esmtp (Exim 4.69) (envelope-from ) id 1OKWBA-0002Hv-Nc for pgsql-performance@postgresql.org; Fri, 04 Jun 2010 14:39:16 +0200 Received: from localhost (localhost [127.0.0.1]) by data.antarean.org (Postfix) with ESMTP id 4D2B79BC for ; Fri, 4 Jun 2010 14:39:16 +0200 (CEST) X-Virus-Scanned: amavisd-new at antarean.org Received: from data.antarean.org ([127.0.0.1]) by localhost (data.antarean.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 6Ye6e3xrd22c for ; Fri, 4 Jun 2010 14:39:16 +0200 (CEST) Received: from eve.localnet (eve.lan.antarean.org [10.20.13.50]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by data.antarean.org (Postfix) with ESMTPS id DB0A9711 for ; Fri, 4 Jun 2010 14:39:15 +0200 (CEST) From: "J. Roeleveld" To: pgsql-performance@postgresql.org Subject: Re: How filesystems matter with PostgreSQL Date: Fri, 4 Jun 2010 14:39:15 +0200 User-Agent: KMail/1.12.4 (Linux/2.6.30-gentoo-r5; KDE/4.3.5; x86_64; ; ) References: <4C08EEDF.7090403@mtu.net> In-Reply-To: <4C08EEDF.7090403@mtu.net> MIME-Version: 1.0 Content-Type: Text/Plain; charset="utf-8" Content-Transfer-Encoding: 7bit Message-Id: <201006041439.15237.joost@antarean.org> X-ZiggoSMTP-MailScanner-Information: Please contact the ISP for more information X-ZiggoSMTP-MailScanner-ID: 1OKWBA-0002Hv-Nc X-ZiggoSMTP-MailScanner: Found to be clean X-ZiggoSMTP-MailScanner-SpamCheck: geen spam, SpamAssassin (niet cached, score=1.154, vereist 5, BAYES_60 1.00, TW_KF 0.08, TW_MK 0.08) X-ZiggoSMTP-MailScanner-SpamScore: s X-ZiggoSMTP-MailScanner-From: joost@antarean.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.8 tagged_above=-10 required=5 tests=BAYES_50=0.8, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201006/78 X-Sequence-Number: 38934 On Friday 04 June 2010 14:17:35 Jon Schewe wrote: > 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 > Hi Jon, Any chance you can do the same test with reiserfs? Thanks, Joost