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(at)cynic(dot)net> +81 90 7737 2974 http://www.netbsd.org
Don't you know, in this new Dark Age, we're all light. --XTC