Re: [seanc@FreeBSD.org: Re: Performance tests I did with - Mailing list pgsql-hackers

From Curt Sampson
Subject Re: [seanc@FreeBSD.org: Re: Performance tests I did with
Date
Msg-id Pine.NEB.4.51.0308291145270.1359@angelic-vtfw.cvpn.cynic.net
Whole thread Raw
In response to [seanc@FreeBSD.org: Re: Performance tests I did with FreeBSD, Linux and PostgreSQL]  (Sean Chittenden <sean@chittenden.org>)
List pgsql-hackers
On Wed, 27 Aug 2003, Sean Chittenden wrote:

> FreeBSD uses 16K blocks for its FS...

Actually, FreeBSD can use 8K blocks as well. The reason for using 16K
blocks is not speeed, but to reduce filesystem overhead and, more
importantly, to allow larger cylinder groups. But for a database with
a lot of random access of small records, your caching will probably
do better if you use 8K filesystem blocks; you're like to be able to
effectively cache more data.

cjs
--
Curt Sampson  <cjs@cynic.net>   +81 90 7737 2974   http://www.NetBSD.org
    Don't you know, in this new Dark Age, we're all light.  --XTC

pgsql-hackers by date:

Previous
From: Neil Conway
Date:
Subject: Re: Bumping block size to 16K on FreeBSD...
Next
From: "Marc G. Fournier"
Date:
Subject: Re: Bumping block size to 16K on FreeBSD...