Re: ProstGreSQL on RAID Question

On Fri, 16 Aug 2002, Chris Ruprecht wrote:

> Thanks Curt - yes, I have the log files on a different drive all
> together. I was thinking more along the lines of OS block size (4 KB)
> vs. Postgres block size (8 KB by default) vs. RAID block size (32 KB).
> Is there anything I should change?

The RAID stripe size is not a big deal; generally you want to keep
it smallish to maximize the number of outstanding requests you can
service at the same time, but I find more often that it's the raid
controller limiting me on this point.

OS block size might as well be the same as postgresql block size;
making it smaller just increases the chances that a block you need
will only be "half" in the cache, and thus require a disk read
anyway.

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