Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id AFB414764CF for ; Sun, 26 Jan 2003 00:35:29 -0500 (EST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id ADE38476902 for ; Sun, 26 Jan 2003 00:34:43 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.6/8.12.6) with ESMTP id h0Q5Ym5u026593; Sun, 26 Jan 2003 00:34:48 -0500 (EST) To: pgsql@vinz.nl Cc: pgsql-performance@postgresql.org Subject: Re: Mount options for Ext3? In-reply-to: <20030125232154.GK14898@md2.mediadesign.nl> References: <200301241120.14404.josh@agliodbs.com> <20030125003011.GA28252@filer> <28176.1043457408@sss.pgh.pa.us> <20030125021159.GC28252@filer> <1260.1043463535@sss.pgh.pa.us> <20030125232154.GK14898@md2.mediadesign.nl> Comments: In-reply-to pgsql.spam@vinz.nl message dated "Sun, 26 Jan 2003 00:21:54 +0100" Date: Sun, 26 Jan 2003 00:34:48 -0500 Message-ID: <26592.1043559288@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/336 X-Sequence-Number: 983 pgsql.spam@vinz.nl writes: > If one were certain his OS wouldn't do any re-ordering of writes, would it be > safe to run with fsync = off? (not that I'm going to try this, but I'm just > curious) I suppose so ... but if your OS doesn't do *any* re-ordering of writes, I'd say you need a better OS. Even in Postgres, we'd often like the OS to collapse multiple writes of the same disk page into one write. And we certainly want the various writes forced by a sync() to be done with some intelligence about disk layout, not blindly in order of issuance. regards, tom lane