Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 418846330F6 for ; Fri, 4 Jun 2010 12:29:27 -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 96757-06 for ; Fri, 4 Jun 2010 15:29:20 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-wy0-f174.google.com (mail-wy0-f174.google.com [74.125.82.174]) by mail.postgresql.org (Postfix) with ESMTP id 228DB63234F for ; Fri, 4 Jun 2010 12:29:19 -0300 (ADT) Received: by wyi11 with SMTP id 11so941273wyi.19 for ; Fri, 04 Jun 2010 08:29:19 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:from:to:subject:date :user-agent:cc:references:in-reply-to:mime-version:content-type :content-transfer-encoding:message-id; bh=qCCjCllFCycHwbGRjuBWUTRtRQnQVRPWrK0Bx0pH3TM=; b=v0TJULsYdXdsismfLTMEX1r/hbDsYtk09fLEi6paArDSGi6ev1UXcj64Mri1expzmW mDL/0+BtbSJ7/WhubtXclhK6sVNqIv1YrQr/OIlGnhxv7mGoQtMlNT3S5GM8Qt4eOGVR ftwxh3MsTtoG3jVCNmZDJ47+Xl/VlYpWDJlUA= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=from:to:subject:date:user-agent:cc:references:in-reply-to :mime-version:content-type:content-transfer-encoding:message-id; b=uGs6Zza1Dp/I6tL92GCeT40lSCeE/MIw4K4vKtQy88uiiOncctUHd8oZzMeP6QhZfm yHY9YRLjZoUKRjF8zfl/TS0jR34irkPlRzopQpjwfvfxLQK49GfRvgqVAlaevgjQyADX mb5VwMuzv3m+1PnmmFcZea0IDJNBrBt4XPrDM= Received: by 10.216.170.70 with SMTP id o48mr2308393wel.71.1275665350439; Fri, 04 Jun 2010 08:29:10 -0700 (PDT) Received: from marco-dalibo.localnet (gev44-1-78-228-108-65.fbx.proxad.net [78.228.108.65]) by mx.google.com with ESMTPS id x9sm819637wej.21.2010.06.04.08.29.05 (version=SSLv3 cipher=RC4-MD5); Fri, 04 Jun 2010 08:29:07 -0700 (PDT) From: Marc Cousin To: Tom Lane Subject: Re: performance regression with Linux 2.6.33 and glibc 2.12 Date: Fri, 4 Jun 2010 17:29:04 +0200 User-Agent: KMail/1.13.3 (Linux/2.6.34-ARCH; KDE/4.4.3; x86_64; ; ) Cc: pgsql-performance@postgresql.org References: <201006041539.03868.cousinmarc@gmail.com> <2135.1275659945@sss.pgh.pa.us> In-Reply-To: <2135.1275659945@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: Text/Plain; charset="iso-8859-6" Content-Transfer-Encoding: 7bit Message-Id: <201006041729.04321.cousinmarc@gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.5 tagged_above=-10 required=5 tests=BAYES_05=-0.5 X-Spam-Level: X-Archive-Number: 201006/91 X-Sequence-Number: 38947 The Friday 04 June 2010 15:59:05, Tom Lane wrote : > Marc Cousin writes: > > I hope I'm not going to expose an already known problem, but I couldn't > > find it mailing list archives (I only found > > http://archives.postgresql.org/pgsql- hackers/2009-12/msg01543.php). > > You sure this isn't the well-known "ext4 actually implements fsync > where ext3 didn't" issue? > > regards, tom lane Everything is ext4. So I should have fsync working with write barriers on all the tests. I don't think this problem is of the same kind: I think it is really because of O_DSYNC appearing on 2.6.33, and PostgreSQL using it by default now. If my filesystem was lying to me about barriers, I should take no more performance hit with open_datasync than with fdatasync, should I ?