X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D20465298F for ; Thu, 4 Aug 2005 10:25:03 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 36165-03 for ; Thu, 4 Aug 2005 13:24:54 +0000 (GMT) Received: from kernel.net.uy (genova.kernel.net.uy [200.58.129.2]) by svr1.postgresql.org (Postfix) with SMTP id 7AF1352B65 for ; Thu, 4 Aug 2005 10:24:49 -0300 (ADT) Received: (qmail 9104 invoked by uid 89); 4 Aug 2005 14:02:38 -0000 Received: from unknown (HELO fabio) (192.168.1.5) by 0 with SMTP; 4 Aug 2005 14:02:38 -0000 Reply-To: From: "Fabio C. Bon" To: Subject: Questions about fsync Date: Thu, 4 Aug 2005 10:22:56 -0300 Message-ID: <02a801c598f7$a0e58e70$0501a8c0@fabio> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook CWS, Build 9.0.2416 (9.0.2910.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Importance: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200508/45 X-Sequence-Number: 18364 In the context of PostgreSQL 7.4, running over Linux Suse 9.0, I have some doubts that wanted to evacuate: In which processes impacts the property fsync? Which can be the problem to use fsync in false? When use fsync = false, the effective recording of the data in disk is done for criteria of the operating system, ¿ Is exact? Considering fsync = false, checkpoint_timeout=300. It given a crash of the operating system, after normally db shutdown. At db startup, there was corruption of data and a pg_resetlog was done. It is possible to lose data changed previous to last checkpoint ? Thanks, Fabio