From owner-freebsd-database@FreeBSD.ORG Sat Nov 12 02:34:46 2005 Return-Path: X-Original-To: freebsd-database@freebsd.org Delivered-To: freebsd-database@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 2410716A41F for ; Sat, 12 Nov 2005 02:34:46 +0000 (GMT) (envelope-from dryice@hotpop.com) Received: from smtp-out.hotpop.com (smtp-out.hotpop.com [38.113.3.71]) by mx1.FreeBSD.org (Postfix) with ESMTP id B7C0043D45 for ; Sat, 12 Nov 2005 02:34:45 +0000 (GMT) (envelope-from dryice@hotpop.com) Received: from hotpop.com (kubrick.hotpop.com [38.113.3.105]) by smtp-out.hotpop.com (Postfix) with SMTP id 8EF021A80201 for ; Sat, 12 Nov 2005 02:34:42 +0000 (UTC) Received: from dryice.3322.org (unknown [221.0.236.221]) by smtp-1.hotpop.com (Postfix) with ESMTP id ABBC01A0265 for ; Sat, 12 Nov 2005 02:34:35 +0000 (UTC) To: freebsd-database@freebsd.org References: <200511111824.jABIO4Sh074288@lurza.secnetix.de> From: Dryice Liu Date: Sat, 12 Nov 2005 10:32:52 +0800 In-Reply-To: <200511111824.jABIO4Sh074288@lurza.secnetix.de> (Oliver Fromme's message of "Fri, 11 Nov 2005 19:24:04 +0100 (CET)") Message-ID: <86ek5msii3.fsf@dryice.3322.org> User-Agent: Gnus/5.11 (Gnus v5.11) Emacs/23.0.0 (berkeley-unix) MIME-Version: 1.0 Content-Type: multipart/signed; boundary="=-=-="; micalg=pgp-sha1; protocol="application/pgp-signature" X-HotPOP: ----------------------------------------------- Sent By HotPOP.com FREE Email Get your FREE POP email at www.HotPOP.com ----------------------------------------------- Subject: Re: suggested block size for a frequently updated postgresql? X-BeenThere: freebsd-database@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Database use and development under FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 12 Nov 2005 02:34:46 -0000 --=-=-= Content-Transfer-Encoding: quoted-printable Oliver Fromme wrote: > Dryice Liu wrote: > > I'm planning on setting up a postgresql server, the database data > > files are on their own slice so I can tune the file system for pgsql. > >=20 > > The database is pretty large. On my test server, some data files get > > larger than 1G and is splitted by pgsql. Also the database will be > > updated frequently. > >=20 > > I'm planning on setting the slice with a bigger block size/fragment > > size but not sure if that's a good idea. I know the default on FreeBSD > > is 16K/2K, I'm planning on something like 1M/128K. > > So, the bottom line is: I recommend you leave the bsize > and fsize at the default 16K/2K. However, you probably > should reduce the inode density from the default, i.e. use > the -i option with some high value such as 262144 (that's > 2^18). But don't make this value too high either ... > I remember someone tried to set it to 64 million or some- > thing, which broke his FS. Thanks for the detail explanation and suggestion! =2D-=20 Dryice @ http://dryice.3322.org Please avoid sending me Word or PowerPoint attachments. See http://www.gnu.org/philosophy/sylvester-response.html --=-=-= Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2 (FreeBSD) iD8DBQBDdVSZa1t4qHe2eHQRAsy2AJ4hY0TgXjeO5tLQZERgnBtbBGuqQgCfT5+M RWfSgzQ6PhAdhJOS5rR8xog= =IH8u -----END PGP SIGNATURE----- --=-=-=--