| From: | Chris Ruprecht <chrup(at)earthlink(dot)net> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | ProstGreSQL on RAID Question |
| Date: | 2002-08-12 06:20:53 |
| Message-ID: | 200208120220.53688.chrup@earthlink.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ludwig Lim | 2002-08-12 07:28:08 | pgstat error |
| Previous Message | Tom Lane | 2002-08-12 05:50:26 | Re: abnormally long time in performing a two-table join |