Re: OS block size vs. DB block size

From: Nabil Courdy <moab_at_emirates.net.ae>
Date: 1998/03/25
Message-ID: <6fc3ai$r23@ws1.emirates.net.ae>#1/1

>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.

I'd go with the logical block size since your IO will be buffered unless you are using RAW devices. In any case, I would not choose a DB block size larger that 4K unless it is a datawarehouse application.

Nabil Courdy

Received on Wed Mar 25 1998 - 00:00:00 CST