From owner-freebsd-fs@FreeBSD.ORG  Mon Jun 11 03:11:24 2007
Return-Path: <owner-freebsd-fs@FreeBSD.ORG>
X-Original-To: freebsd-fs@freebsd.org
Delivered-To: freebsd-fs@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52])
	by hub.freebsd.org (Postfix) with ESMTP id AA0F116A468
	for <freebsd-fs@freebsd.org>; Mon, 11 Jun 2007 03:11:24 +0000 (UTC)
	(envelope-from lists@stringsutils.com)
Received: from zoraida.natserv.net (p65-147.acedsl.com [66.114.65.147])
	by mx1.freebsd.org (Postfix) with ESMTP id 765D213C483
	for <freebsd-fs@freebsd.org>; Mon, 11 Jun 2007 03:11:24 +0000 (UTC)
	(envelope-from lists@stringsutils.com)
Received: by zoraida.natserv.net (Postfix, from userid 58)
	id D7E37C2E9; Sun, 10 Jun 2007 23:11:23 -0400 (EDT)
X-Spam-Checker-Version: SpamAssassin 3.1.8 (2007-02-13) on zoraida.natserv.net
X-Spam-Level: 
X-Spam-Status: No, score=-1.4 required=4.0 tests=ALL_TRUSTED,
	DK_POLICY_SIGNSOME autolearn=disabled version=3.1.8
X-Spam-Report: * 0.0 DK_POLICY_SIGNSOME Domain Keys: policy says domain signs some
	mails
	* -1.4 ALL_TRUSTED Passed through trusted hosts only via SMTP
Received: from zoraida.natserv.net (zoraida.natserv.net [66.114.65.147])
	by zoraida.natserv.net (Postfix) with ESMTP id A7E8FC2AF
	for <freebsd-fs@freebsd.org>; Sun, 10 Jun 2007 23:11:21 -0400 (EDT)
Message-ID: <cone.1181531481.451392.13436.1000@zoraida.natserv.net>
X-Mailer: http://www.courier-mta.org/cone/
From: Francisco Reyes <lists@stringsutils.com>
To: FreeBSD Filesystem <freebsd-fs@freebsd.org>
Date: Sun, 10 Jun 2007 23:11:21 -0400
Mime-Version: 1.0
Content-Type: text/plain; format=flowed; charset="US-ASCII"
Content-Disposition: inline
Content-Transfer-Encoding: 7bit
Subject: Inode density for database machines - newfs -i
X-BeenThere: freebsd-fs@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Filesystems <freebsd-fs.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-fs>,
	<mailto:freebsd-fs-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-fs>
List-Post: <mailto:freebsd-fs@freebsd.org>
List-Help: <mailto:freebsd-fs-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-fs>,
	<mailto:freebsd-fs-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Mon, 11 Jun 2007 03:11:24 -0000

For my mailstore machines I usually do "newfs -i 32768" to decrease fsck 
time in case of problems.

For database machines, postgresql in particular, would it help to have a 
number larger than 65536?

I am aware that ZFS and gjournal are in the horizon, but I am looking at the 
next 3 months and neither of those two may be mature enough to even get 
approval to install them.

Looking at one of my existing database machines, I have a filesystem using 
1.2TB and only 2053 inodes. There are 3,539,385 free inodes. If I recall 
correctly I used "newfs -i 65536" for that filesystem.

Will fsck be significantly faster in case of crash if I used say 
131072(128K)  or even 256K?

What is the best list to find the current status of gjournal?
This list of geom? Looking at archives most of the gjournal posts seem to be 
in current.