Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 82AAF133655C for ; Wed, 6 Apr 2011 19:40:35 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 75780-05 for ; Wed, 6 Apr 2011 22:40:27 +0000 (UTC) X-Greylist: delayed 00:06:39.502683 by SQLgrey-1.7.6 Received: from mx4.wp.pl (mx4.wp.pl [212.77.101.8]) by mail.postgresql.org (Postfix) with ESMTP id 73FE31337BB7 for ; Wed, 6 Apr 2011 19:40:26 -0300 (ADT) Received: (wp-smtpd smtp.wp.pl 17403 invoked from network); 7 Apr 2011 00:33:42 +0200 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=wp.pl; s=1024a; t=1302129222; bh=eU9IUOozMvsws9ELCM8fEGTR9bpHhsUF2Z2jN0KOmKo=; h=From:To:Subject; b=tt2kvUgaRWjX37SSlbEE1HnxsiPDMVGSYiecwypTXogo4uKAjIAhBhNRSXr0zofI8 y0e0Wgyhzkjn3vLLmNolbRIl8U3SJxRETmAJUs476Zyn9Ez8HD6gCc3k3ukI3f5ERP 8lF6JOpthOkWlfiBYXQecVLdW+q+2wc0C/ZIAL2I= Received: from aayr148.neoplus.adsl.tpnet.pl (HELO [10.0.0.101]) (ipluta@[83.6.129.148]) (envelope-sender ) by smtp.wp.pl (WP-SMTPD) with AES256-SHA encrypted SMTP for ; 7 Apr 2011 00:33:42 +0200 Message-ID: <4D9CEA3F.5050603@wp.pl> Date: Thu, 07 Apr 2011 00:33:35 +0200 From: Ireneusz Pluta User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; pl; rv:1.9.2.15) Gecko/20110303 Lightning/1.0b2 Thunderbird/3.1.9 MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Background fsck Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-WP-AV: skaner antywirusowy poczty Wirtualnej Polski S. A. X-WP-SPAM: NO 0000000 [YaPE] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.899 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, T_RP_MATCHES_RCVD=-0.01, T_TO_NO_BRKTS_FREEMAIL=0.01 X-Spam-Level: X-Archive-Number: 201104/53 X-Sequence-Number: 43115 Hello, I saw some recommendations from people on the net not to use background fsck when running PostgreSQL on FreeBSD. As I recall, these opinions were just thoughts of people which they shared with the community, following their bad experience caused by using background fsck. So, not coming any deeper with underatanding why not, I use that as a clear recommendation for myself and keep background fsck turned off on all my machines, regardless how much faster a server could come up after a crash. But waiting so much time (like now) during foreground fsck of a large data filesystem after unclean shutdown, makes me to come to this group to ask whether I really need to avoid background fsck on a PostgreSQL machine? Could I hear your opinions? Thanks Irek.