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 EA3C4D1ED2B; Fri, 26 Mar 2004 16:55:21 +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 67140-04; Fri, 26 Mar 2004 12:55:24 -0400 (AST) Received: from candle.pha.pa.us (candle.pha.pa.us [207.106.42.251]) by svr1.postgresql.org (Postfix) with ESMTP id AFD7ED1ED32; Fri, 26 Mar 2004 12:55:17 -0400 (AST) Received: (from pgman@localhost) by candle.pha.pa.us (8.11.6/8.11.6) id i2QGsxt04146; Fri, 26 Mar 2004 11:54:59 -0500 (EST) From: Bruce Momjian Message-Id: <200403261654.i2QGsxt04146@candle.pha.pa.us> Subject: Re: [HACKERS] fsync method checking In-Reply-To: <200403261609.i2QG9l220991@mail.osdl.org> To: markw@osdl.org Date: Fri, 26 Mar 2004 11:54:59 -0500 (EST) 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 X-Mailer: ELM [version 2.4ME+ PL108 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/376 X-Sequence-Number: 6232 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? -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073