Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 5A4F61336FA7 for ; Fri, 8 Apr 2011 07:22:31 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 37972-09 for ; Fri, 8 Apr 2011 10:22:12 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from lo.gmane.org (lo.gmane.org [80.91.229.12]) by mail.postgresql.org (Postfix) with ESMTP id 441F01337BE6 for ; Fri, 8 Apr 2011 07:22:11 -0300 (ADT) Received: from list by lo.gmane.org with local (Exim 4.69) (envelope-from ) id 1Q88pO-0008I0-U5 for pgsql-performance@postgresql.org; Fri, 08 Apr 2011 12:22:10 +0200 Received: from lara.cc.fer.hr ([161.53.72.113]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Fri, 08 Apr 2011 12:22:10 +0200 Received: from ivoras by lara.cc.fer.hr with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Fri, 08 Apr 2011 12:22:10 +0200 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-performance@postgresql.org From: Ivan Voras Subject: Re: Background fsck Date: Fri, 08 Apr 2011 12:21:50 +0200 Lines: 21 Message-ID: References: <4D9CEA3F.5050603@wp.pl> <201104071701.02647.achill@matrix.gatewaynet.com> <4D9EA367.7060102@wp.pl> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@dough.gmane.org X-Gmane-NNTP-Posting-Host: lara.cc.fer.hr User-Agent: Mozilla/5.0 (X11; U; FreeBSD amd64; en-US; rv:1.9.2.12) Gecko/20101102 Thunderbird/3.1.6 In-Reply-To: <4D9EA367.7060102@wp.pl> X-Enigmail-Version: 1.1.2 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201104/82 X-Sequence-Number: 43144 On 08/04/2011 07:55, Ireneusz Pluta wrote: > Achilleas Mantzios wrote: >> >> In anyway, having FreeBSD to fsck, (background or not) should not >> happen. And the problem >> becomes bigger when cheap SATA drives will cheat about their write >> cache being flushed to the disk. >> So in the common case with cheap hardware, it is wise to have a UPS >> connected and being monitored >> by the system. >> > > It's not lack of UPS. Power issues are taken care of here. It's a buggy > 3ware controller which hangs the machine ocassionally and the only way > to have it come back is to power cycle, hard reset is not enough. So just to summarize your position: you think it is ok to run a database on a buggy disk controller but are afraid of problems with normal OS utilities? :) You are of course free to do whatever you want but it seems odd :)