Re: ProstGreSQL on RAID Question

Поиск
Список
Период
Сортировка
От Curt Sampson
Тема Re: ProstGreSQL on RAID Question
Дата
Msg-id Pine.NEB.4.44.0208171530150.472-100000@angelic.cynic.net
обсуждение исходный текст
Ответ на Re: ProstGreSQL on RAID Question  (Chris Ruprecht <chrup@earthlink.net>)
Список pgsql-admin
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


В списке pgsql-admin по дате отправления:

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: Attribute 'name' not found
Следующее
От: "Daniel L Banta"
Дата:
Сообщение: Re: Fw: OID