Re: OS block size vs. DB block size

The Solaris filesystem defaults to 8K blocks, although you can set it up with 4K. You might want to look at the "newfs" command for other options. We setup a small warehousing/mining DB using 8K DB blocks, and played around with some of the newfs params (-f 8192 -i 10485760 -m 2) with good results, although we changed a number of other things too. note that the 8K DB block size might not be too good for OLTP applications, though.

-Peter

S S Wan wrote:

> Hello all,
>
> I was confused by the documents from SUN. They said
> that the logical filesystem block size is 8192 bytes but
> the physical block size is 512 bytes. My concern is which
> figure I should take to consider the DB block size, which
> should be integral multiple of the OS block size.
>
> Does anyone have insight?
Received on Wed Mar 25 1998 - 00:00:00 CST