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 53D1B52881 for ; Sat, 30 Jul 2005 13:01:57 -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 83912-10 for ; Sat, 30 Jul 2005 16:01:55 +0000 (GMT) Received: from hub.org (hub.org [200.46.204.220]) by svr1.postgresql.org (Postfix) with ESMTP id D590F528EB for ; Sat, 30 Jul 2005 13:01:54 -0300 (ADT) Received: from localhost (unknown [200.46.204.144]) by hub.org (Postfix) with ESMTP id 9AD3AA246D7 for ; Sat, 30 Jul 2005 13:01:54 -0300 (ADT) Received: from hub.org ([200.46.204.220]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 89255-01 for ; Sat, 30 Jul 2005 16:01:45 +0000 (GMT) Received: from ganymede.hub.org (blk-224-176-51.eastlink.ca [24.224.176.51]) by hub.org (Postfix) with ESMTP id 48A2DA2465F for ; Sat, 30 Jul 2005 13:01:45 -0300 (ADT) Received: by ganymede.hub.org (Postfix, from userid 1000) id C7BEA345A1; Sat, 30 Jul 2005 13:01:44 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by ganymede.hub.org (Postfix) with ESMTP id C3AB734529 for ; Sat, 30 Jul 2005 13:01:44 -0300 (ADT) X-Return-Path: X-Received: from ganymede.hub.org ([unix socket]) by ganymede.hub.org (Cyrus v2.2.12) with LMTPA; Fri, 29 Jul 2005 13:35:37 -0300 X-Sieve: CMU Sieve 2.2 X-Received: from localhost (localhost [127.0.0.1]) by ganymede.hub.org (Postfix) with ESMTP id EF2D348A14 for ; Fri, 29 Jul 2005 13:35:36 -0300 (ADT) X-Received: from mail.postgresql.org [200.46.204.71] by localhost with IMAP (fetchmail-6.2.5) for scrappy@localhost (single-drop); Fri, 29 Jul 2005 13:35:36 -0300 (ADT) X-Received: from svr1.postgresql.org ([unix socket]) by svr1.postgresql.org (Cyrus v2.2.12) with LMTPA; Fri, 29 Jul 2005 13:32:47 -0300 X-Sieve: CMU Sieve 2.2 X-Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C9EFC52A24 for ; Fri, 29 Jul 2005 13:32:47 -0300 (ADT) X-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 83632-02 for ; Fri, 29 Jul 2005 16:32:46 +0000 (GMT) X-Received: from postgresql.org (svr1.postgresql.org [200.46.204.71]) by svr1.postgresql.org (Postfix) with ESMTP id 5FC7652A15 for ; Fri, 29 Jul 2005 13:32:46 -0300 (ADT) X-Original-To: pgsql-admin-postgresql.org-owner@localhost.postgresql.org X-Delivered-To: pgsql-admin-postgresql.org-owner@localhost.postgresql.org X-Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C8FD5529E9 for ; Fri, 29 Jul 2005 13:32:45 -0300 (ADT) X-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 84000-03 for ; Fri, 29 Jul 2005 16:32:41 +0000 (GMT) X-Received: from kernel.net.uy (genova.kernel.net.uy [200.58.129.2]) by svr1.postgresql.org (Postfix) with SMTP id 81366528D7 for ; Fri, 29 Jul 2005 13:32:39 -0300 (ADT) X-Received: (qmail 20916 invoked by uid 89); 29 Jul 2005 17:08:37 -0000 X-Received: from unknown (HELO fabio) (192.168.1.5) by 0 with SMTP; 29 Jul 2005 17:08:37 -0000 Reply-To: From: "Fabio C. Bon" To: Subject: Questions about fsync Date: Fri, 29 Jul 2005 13:30:46 -0300 Message-ID: <025b01c5945a$dfc1ba70$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-Virus-Scanned: by amavisd-new at hub.org ReSent-Date: Sat, 30 Jul 2005 13:01:40 -0300 (ADT) Resent-From: "Marc G. Fournier" Resent-To: pgsql-admin@postgresql.org ReSent-Subject: Questions about fsync ReSent-Message-ID: <20050730130140.V965@ganymede.hub.org> X-Virus-Scanned: by amavisd-new at hub.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.946 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200508/48 X-Sequence-Number: 18367 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