Hello all, I realise this is a little off-topic, however I have been unable to find a more suitable newsgroup aside from linux.postgres which is basically dead.
This weekend I will be building a couple of new postgres database servers under RH7.3, and I am currently deciding between 2 different configuration options. The new servers feature hot-swappable RAID w/ 3 hard drives in each. Option #1 Use one drive for the linux boot partition, a second for the database data, and the third to store the indexes. I have heard this can offer a reasonable performance advantage by reducing the read/writes on any particular SCSI channel/drive and speeding up lookups due to the dedicated index drive. Option #2 Simply set the server up with RAID level 5 and run everything from the one RAID partition. This would allow us to take advantage of the hot-swappable features and would probably be more reliable. >From my understanding of hardware RAID, the striped disk array should offer optimum performance anyway, as the read/writes would be striped in clusters across the disks, however I can see how the use of the dedicated index drive would speed up the use of indexes (but with reduced performance on the data reads in comparison to RAID). If anyone has experience with either of these configurations, or can offer any other suggestions for best performance/reliability I would really appreciate the input. Thank you in advance. -- David Kennedy ALFCO Communications ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
