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 474D8D1E934; Sat, 20 Mar 2004 03:48:15 +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 16938-04; Fri, 19 Mar 2004 23:48:17 -0400 (AST) Received: from filer (c-24-6-183-218.client.comcast.net [24.6.183.218]) by svr1.postgresql.org (Postfix) with ESMTP id 3B53CD1E8AB; Fri, 19 Mar 2004 23:48:13 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) (uid 1000) by filer with local; Fri, 19 Mar 2004 19:48:17 -0800 Date: Fri, 19 Mar 2004 19:48:17 -0800 From: Kevin Brown To: pgsql-performance@postgresql.org, PostgreSQL-development Subject: Re: [HACKERS] fsync method checking Message-ID: <20040320034817.GA9566@filer> Mail-Followup-To: Kevin Brown , pgsql-performance@postgresql.org, PostgreSQL-development References: <200403182049.i2IKnKK00246@candle.pha.pa.us> <12315.1079643885@sss.pgh.pa.us> <20040319004112.GA19547@filer> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Content-Disposition: inline In-Reply-To: <20040319004112.GA19547@filer> Organization: Frobozzco International User-Agent: Mutt/1.5.4i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/281 X-Sequence-Number: 6137 I wrote: > Note, too, that the preferred method isn't likely to depend just on the > operating system, it's likely to depend also on the filesystem type > being used. > > Linux provides quite a few of them: ext2, ext3, jfs, xfs, and reiserfs, > and that's just off the top of my head. I imagine the performance of > the various syncing methods will vary significantly between them. For what it's worth, my database throughput for transactions involving a lot of inserts, updates, and deletes is about 12% faster using fdatasync() than O_SYNC under Linux using JFS. I'll run the test program and report my results with it as well, so we'll be able to see if there's any consistency between it and the live database. -- Kevin Brown kevin@sysexperts.com