Re: What is a good blocksize to use.

Ben Brugman wrote:
>
> For a transactional machine, where most rows contain a few hundred
> byte. Assume a RAID (1/0) device as storage medium.
>
> What is a good blocksize, and why ?
>
> What are the effects of going smaller in blocksize ?
> What are the effects of going larger in blocksize ?
>
> ben brugman
> Ben Brugman

To reduce a large discussion to a couple of simplistic views:

• big is beautiful
• blocksize same as filesystem block size

(37 pages of caveats and additional content omitted)

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."