X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 62E899DCC34 for ; Tue, 28 Feb 2006 19:31:38 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 39150-07 for ; Tue, 28 Feb 2006 19:31:40 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from peufeu.com (unknown [82.67.9.10]) by postgresql.org (Postfix) with ESMTP id C73189DCC49 for ; Tue, 28 Feb 2006 19:31:35 -0400 (AST) Received: (qmail 24288 invoked from network); 1 Mar 2006 00:31:34 +0100 Received: from unknown (HELO apollo13) (82.67.9.10) by boutiquenumerique.com with SMTP; 1 Mar 2006 00:31:34 +0100 To: "Bruce Momjian" , "Javier Somoza" Cc: "Evgeny Gridasov" , pgsql-performance@postgresql.org Subject: Re: wal sync method References: <200602280114.k1S1EAQ17159@candle.pha.pa.us> Message-ID: Date: Wed, 01 Mar 2006 00:31:33 +0100 From: PFC Content-Type: text/plain; format=flowed; delsp=yes; charset=utf-8 MIME-Version: 1.0 Content-Transfer-Encoding: 8bit In-Reply-To: <200602280114.k1S1EAQ17159@candle.pha.pa.us> User-Agent: Opera M2/8.51 (Linux, build 1462) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.104 required=5 tests=[AWL=0.104] X-Spam-Score: 0.104 X-Spam-Level: X-Archive-Number: 200602/446 X-Sequence-Number: 17432 Just a stupid question about the various fsync settings. There is fsync=off, but is there fsync=fflush ? fflush would mean only an OS crash could cause data loss, I think.it could be useful for some applications where you need a speed boost (like testing database import scripts...) without being as scary as fsync=off...