Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id C19F11337B9C for ; Wed, 6 Apr 2011 19:48:33 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 15718-02 for ; Wed, 6 Apr 2011 22:48:24 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-iy0-f174.google.com (mail-iy0-f174.google.com [209.85.210.174]) by mail.postgresql.org (Postfix) with ESMTP id 1A1BC1337A5D for ; Wed, 6 Apr 2011 19:48:22 -0300 (ADT) Received: by iyb14 with SMTP id 14so1890299iyb.19 for ; Wed, 06 Apr 2011 15:48:23 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:in-reply-to:references:date :message-id:subject:from:to:cc:content-type; bh=Qxse5WciHq+slAmHYKmFq5Q+fXh/GqcejAFVeiFA1ao=; b=vg9gN+qH+FFFswC4rRf3azExEi6is5plzuhtCknIsWCeUqOEGO2GQSKBG7q3KQqA9V qMvhXKaP8bvBM6kIOTadWcAuYFmJNMYWnBmBncL4oKcbbU1q2230KL9r7zVN+drM7JFb Acgvfd2C3w8ZlOTCVEkIDck4iEqmJF01m+x1Q= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; b=DHcSyQXsHYrtfGlE0nVxZvt78LmG9E4YwmoeCi7qmo/HeLyC81Hfkk+lWFeKWG9Us4 k1IL2mlOXfjCqz9c67lLA6gvcprbrBKz2b/9anTJTDHUO0Q88j9CbvP5JYHNTje3lsxS plDzs4pOqzRU6sFcf4zWSdBxf9jWtnVrJR6fA= MIME-Version: 1.0 Received: by 10.231.16.135 with SMTP id o7mr177128iba.66.1302130102991; Wed, 06 Apr 2011 15:48:22 -0700 (PDT) Received: by 10.231.154.132 with HTTP; Wed, 6 Apr 2011 15:48:22 -0700 (PDT) In-Reply-To: <4D9CEA3F.5050603@wp.pl> References: <4D9CEA3F.5050603@wp.pl> Date: Wed, 6 Apr 2011 16:48:22 -0600 Message-ID: Subject: Re: Background fsck From: Scott Marlowe To: Ireneusz Pluta Cc: pgsql-performance@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 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 X-Spam-Level: X-Archive-Number: 201104/54 X-Sequence-Number: 43116 On Wed, Apr 6, 2011 at 4:33 PM, Ireneusz Pluta wrote: > 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? Shouldn't a journaling file system just come back up almost immediately?