X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 25C7BD1DCF9; Fri, 26 Mar 2004 23:22:29 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 21994-05; Fri, 26 Mar 2004 19:22:35 -0400 (AST) Received: from gp.word-to-the-wise.com (gp.word-to-the-wise.com [64.71.176.18]) by svr1.postgresql.org (Postfix) with ESMTP id C5B65D1DCED; Fri, 26 Mar 2004 19:22:26 -0400 (AST) Received: by gp.word-to-the-wise.com (Postfix, from userid 500) id 67AA290000D; Fri, 26 Mar 2004 15:14:59 -0800 (PST) Date: Fri, 26 Mar 2004 15:14:59 -0800 From: Steve Atkins To: pgsql-performance@postgresql.org, pgsql-hackers@postgresql.org Subject: Re: [HACKERS] fsync method checking Message-ID: <20040326231459.GA23615@gp.word-to-the-wise.com> References: <200403252147.i2PLkx209812@mail.osdl.org> <4063CCF1.2030307@colorfullife.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <4063CCF1.2030307@colorfullife.com> User-Agent: Mutt/1.4.1i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/389 X-Sequence-Number: 6245 On Fri, Mar 26, 2004 at 07:25:53AM +0100, Manfred Spraul wrote: > >Compare file sync methods with one 8k write: > > (o_dsync unavailable) > > open o_sync, write 6.270724 > > write, fdatasync 13.275225 > > write, fsync, 13.359847 > > > > > Odd. Which filesystem, which kernel? It seems fdatasync is broken and > syncs the inode, too. This may be relevant.