Michelle Konzack wrote:
Am 2005-11-14 16:54:41, schrieb Jim C. Nasby:
On Mon, Nov 14, 2005 at 07:36:44PM +0100, Michelle Konzack wrote:
Hello *,
I have three Sun Server where I have reserved on each Server a Raid-5
of 1 TByte for my PostgreSQL. The first PostgreSQL is up and running
with a database of 150 GByte.
Keep in mind that databases and RAID5 generally don't mix very well.
Can you explain me why?
RAID 5 is very expensive for writes.
Unfortunatly the Controllers in the three SUN-Servers do not support
300 GByte SCSI-Drives, so I have to continue with the Raid-5 of 16x
76 GByte.
Could you do RAID 10?
Sincerely,
Joshua D. Drake
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match