Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id DAA34D32489 for ; Mon, 30 Apr 2012 19:00:35 -0300 (ADT) Received: from plane.gmane.org ([80.91.229.3]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SOye1-0006Vb-1n for pgsql-performance@postgresql.org; Mon, 30 Apr 2012 22:00:34 +0000 Received: from list by plane.gmane.org with local (Exim 4.69) (envelope-from ) id 1SOydm-0001E5-VJ for pgsql-performance@postgresql.org; Tue, 01 May 2012 00:00:18 +0200 Received: from host-188-174-169-133.customer.m-online.net ([188.174.169.133]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Tue, 01 May 2012 00:00:18 +0200 Received: from spam_eater by host-188-174-169-133.customer.m-online.net with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Tue, 01 May 2012 00:00:18 +0200 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-performance@postgresql.org From: Thomas Kellerer Subject: Re: Tuning Postgres 9.1 on Windows Date: Tue, 01 May 2012 00:00:09 +0200 Lines: 9 Message-ID: References: <21BFB59709EBB84DB412ED7F739FFD3B19E5E3@TBPINFN0203.cad.local> Mime-Version: 1.0 Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@dough.gmane.org X-Gmane-NNTP-Posting-Host: host-188-174-169-133.customer.m-online.net User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.8.1.21) Gecko/20090302 Thunderbird/2.0.0.21 Mnenhy/0.7.5.666 In-Reply-To: X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201204/177 X-Sequence-Number: 46823 Merlin Moncure wrote on 30.04.2012 23:43: > Trying turning off fsync in postgrsql.conf to be sure. This is a dangerous advise. Turning off fsync can potentially corrupt the database in case of a system failure (e.g. power outage).