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 5AA72D1EBFE; Fri, 26 Mar 2004 17:01:32 +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 67366-07; Fri, 26 Mar 2004 13:01:36 -0400 (AST) Received: from mail.osdl.org (fw.osdl.org [65.172.181.6]) by svr1.postgresql.org (Postfix) with ESMTP id C0E52D1EBE3; Fri, 26 Mar 2004 13:01:29 -0400 (AST) Received: from osdl.org (markw@ibm-b.pdx.osdl.net [172.20.1.51]) by mail.osdl.org (8.11.6/8.11.6) with ESMTP id i2QH0x203524; Fri, 26 Mar 2004 09:01:00 -0800 Message-Id: <200403261701.i2QH0x203524@mail.osdl.org> Date: Fri, 26 Mar 2004 09:00:56 -0800 (PST) From: markw@osdl.org Subject: Re: [HACKERS] fsync method checking To: pgman@candle.pha.pa.us Cc: manfred@colorfullife.com, tgl@sss.pgh.pa.us, josh@agliodbs.com, Q@ping.be, markir@paradise.net.nz, pgsql-performance@postgresql.org, pgsql-hackers@postgresql.org In-Reply-To: <200403261654.i2QGsxt04146@candle.pha.pa.us> MIME-Version: 1.0 Content-Type: TEXT/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/375 X-Sequence-Number: 6231 On 26 Mar, Bruce Momjian wrote: > markw@osdl.org wrote: >> On 26 Mar, Manfred Spraul wrote: >> > markw@osdl.org 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. >> >> It's linux-2.6.5-rc1 with ext2 filesystems. > > Would you benchmark open_sync for wal_sync_method too? Oh yeah. Will try to get results later today. Mark