On Sat, 3 Jan 1998, Bruce Momjian wrote:
> I believe it is 8k to match the base size for the filesystem block size,
> for performance.
Hrmmm...how does one find out what the file system block size is? I know
there is an option to newfs for changing this, and at least under FreeBSD, the
default is set to:
sys/param.h:#define DFLTBSIZE 4096
So maybe a multiple of block size should be considered more appropriate?
Maybe have it so that you can stipulate # of blocks that equal max tuple size?
Then, if I wanted, I could format a drive with a block size of 16k that is only
going to be used for databases, and have a tuple size up to that level?
Marc G. Fournier
Systems Administrator @ hub.org
primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org
------------------------------
