Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 9FFCA1337B58 for ; Wed, 17 Nov 2010 17:25:06 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 14322-04 for ; Wed, 17 Nov 2010 21:24:59 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.17.9]) by mail.postgresql.org (Postfix) with ESMTP id D56D31337B53 for ; Wed, 17 Nov 2010 17:24:58 -0400 (AST) Received: from [192.168.1.6] (static-71-179-240-8.bltmmd.fios.verizon.net [71.179.240.8]) by mrelayeu.kundenserver.de (node=mreu2) with ESMTP (Nemesis) id 0MWOFC-1OzYcU0Gsc-00XzEi; Wed, 17 Nov 2010 22:24:56 +0100 Message-ID: <4CE44826.2070508@2ndquadrant.com> Date: Wed, 17 Nov 2010 16:24:54 -0500 From: Greg Smith User-Agent: Thunderbird 2.0.0.24 (X11/20100317) MIME-Version: 1.0 To: Scott Carey CC: Marti Raudsepp , "pgsql-performance@postgresql.org" Subject: Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? References: <4CCDCAA3.4050805@2ndquadrant.com> <201011010010.28724.andres@anarazel.de> <4CD472CC.80006@2ndquadrant.com> <4CE2EBF8.4040602@2ndquadrant.com> <499BFB3F-CD9F-47D2-87E4-058C2A6D63EC@richrelevance.com> In-Reply-To: <499BFB3F-CD9F-47D2-87E4-058C2A6D63EC@richrelevance.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Provags-ID: V02:K0:2LV0dbi1Drf8wyg/g+OVe44UFrfnpi0zMTQiHfCv5GR pacWW9uPfclbi40r7VPsd2uiyBcSjhFlb5lcGJZsUCZa/4saSt AeENg0FSGTnokPJdutDSTdgQuMzxFIBFI96BwVOAHyqnDv7rGy sREflQVbnwPpaie3yxXZc12MVZkF2CyhJG4g4664posAyEqkh5 i0dv9qaTJ0+DlVDNKjwmfF4lUrYOQsBvIU0oa2foH0= X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201011/295 X-Sequence-Number: 41319 Scott Carey wrote: > Did you recompile your test on the RHEL6 system? On both systems I showed, I checked out a fresh copy of the PostgreSQL 9.1 HEAD from the git repo, and compiled that on the server, to make sure I was pulling in the appropriate kernel headers. I wasn't aware of exactly how the kernel sync stuff was refactored though, thanks for the concise update on that. I can do similar tests on a RHEL5 system, but not on the same hardware. Can only make my laptop boot so many operating systems at a time usefully. -- Greg Smith 2ndQuadrant US greg@2ndQuadrant.com Baltimore, MD PostgreSQL Training, Services and Support www.2ndQuadrant.us "PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books