ProstGreSQL on RAID Question - Mailing list pgsql-admin

From Chris Ruprecht
Subject ProstGreSQL on RAID Question
Date
Msg-id 200208120220.53688.chrup@earthlink.net
Whole thread Raw
Responses Re: ProstGreSQL on RAID Question
List pgsql-admin
Hi all,

I have set up a RAID-5 (soft RAID) arrray on my Linux machine, consisting of 5
18 GB UltraSCSI-2 (80 MB/sec) drives. Everythinng is working but I would like
to know, where I can tweak this for optimum performance.

The HOWTO, I found, said to set this up using a 32 KB chunk size for the 4 KB
ext2 filesystems. I know that PostGreSQL is using 8 KB blocks, should it
therefore not be better to set up the array, using 8 KB chunks? Or should I
increase the chunk size?

The array is only for use by the $PGDATA directory, nothing else will go
there, so this can be optimized for PG without any  consideration for
anything else.

Any input welcome.

Best regards,
Chris


pgsql-admin by date:

Previous
From: Chris Mungall
Date:
Subject: Re: abnormally long time in performing a two-table join
Next
From: Curt Sampson
Date:
Subject: Re: ProstGreSQL on RAID Question