X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 7BAAED1BA48 for ; Thu, 18 Mar 2004 18:23:26 +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 65391-03 for ; Thu, 18 Mar 2004 14:23:21 -0400 (AST) Received: from trolak.mydnsbox2.com (ns1.mydnsbox2.com [207.44.142.118]) by svr1.postgresql.org (Postfix) with ESMTP id 7E119D1B4D3 for ; Thu, 18 Mar 2004 14:23:14 -0400 (AST) Received: from dunslane.net (cpe-024-211-141-025.nc.rr.com [24.211.141.25]) (authenticated (0 bits)) by trolak.mydnsbox2.com (8.11.6/8.11.6) with ESMTP id i2IJNNn04841 for ; Thu, 18 Mar 2004 13:23:23 -0600 Message-ID: <4059E912.2050509@dunslane.net> Date: Thu, 18 Mar 2004 13:23:14 -0500 From: Andrew Dunstan User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4.1) Gecko/20031114 X-Accept-Language: en-us, en MIME-Version: 1.0 To: PostgreSQL-development Subject: Re: fsync method checking References: <200403181746.i2IHkDA00975@candle.pha.pa.us> In-Reply-To: <200403181746.i2IHkDA00975@candle.pha.pa.us> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/815 X-Sequence-Number: 51407 Bruce Momjian wrote: >I have been poking around with our fsync default options to see if I can >improve them. One issue is that we never default to O_SYNC, but default >to O_DSYNC if it exists, which seems strange. > >What I did was to beef up my test program and get it into CVS for folks >to run. What I found was that different operating systems have >different optimal defaults. On BSD/OS and FreeBSD, fdatasync/fsync was >better, but on Linux, O_DSYNC/O_SYNC was faster. > >[snip] > >Linux 2.4.9: > > This is a pretty old kernel (I am writing from a machine running 2.4.22) Maybe before we do this for Linux testing on a more modern kernel might be wise. cheers andrew