The current king of putting postgresql on multiple platters and getting best overall performance is a battery backed caching raid controller run one or more many disk RAID-5 arrays.
I thought the best choice were RAID-10 (1+0) (when available). There isn't a write penalty with RAID-5?
Thank you. Kind regards,
-- Cris Carampa (spamto:[EMAIL PROTECTED]) The man thinks. The horse thinks. The sheep thinks. The cow thinks. The fish doesn't think: the fish is mute, expressionless. The fish doesn't think, because the fish knows - everything. [Kusturica]
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
