X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 6545056411 for ; Fri, 25 Feb 2005 05:02:41 +0000 (GMT) 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 20494-10 for ; Fri, 25 Feb 2005 05:02:40 +0000 (GMT) Received: from stark.xeocode.com (i216-58-44-227.avalonworks.net [216.58.44.227]) by svr1.postgresql.org (Postfix) with ESMTP id 0E23956381 for ; Fri, 25 Feb 2005 05:02:39 +0000 (GMT) Received: from localhost ([127.0.0.1] helo=stark.xeocode.com) by stark.xeocode.com with smtp (Exim 3.36 #1 (Debian)) id 1D4XcP-0001MU-00; Fri, 25 Feb 2005 00:02:25 -0500 To: Bruce Momjian Cc: Neil Conway , Magnus Hagander , "Vig, Sandor (G/FI-2)" , pgsql-performance@postgresql.org Subject: Re: PostgreSQL is extremely slow on Windows References: <200502242125.j1OLPYF14343@candle.pha.pa.us> In-Reply-To: <200502242125.j1OLPYF14343@candle.pha.pa.us> From: Greg Stark Organization: The Emacs Conspiracy; member since 1992 Date: 25 Feb 2005 00:02:25 -0500 Message-ID: <87ekf5qljy.fsf@stark.xeocode.com> Lines: 14 User-Agent: Gnus/5.09 (Gnus v5.9.0) Emacs/21.3 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200502/355 X-Sequence-Number: 10684 Bruce Momjian writes: > Right now with fsync off you can get transactions partially commited in your > database, which is a serious problem (think moving money from one account to > another). It's worse than that. You can get a totally corrupted database. Things like duplicated records (the before and after image of an update). Or indexes that are out of sync with the table. This can cause strange inconsistent results depending on the plan queries use, or outright database crashes. -- greg