-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 11/24/07 09:12, Scott Marlowe wrote: > On Nov 24, 2007 5:09 AM, Clodoaldo <clodoaldo.pinto.neto@xxxxxxxxx> wrote: >> I will build a cheap server and I'm in doubt about what would the the >> best for performance: >> >> 1 - everything in one lonely fast 10,000 rpm Raptor HD; >> >> 2 - two cheap 7,200 rpm 16MB cache HDs like this: >> >> disk 1 - system and pg_xlog >> disk 2 - pg_data without pg_xlog >> or a better arrange suggested by you; >> >> 3 - The two cheap HDs above in Raid 0. > > From a DBA perspective, none of those seem like a good choice, as > there's no redundancy. > > I'd make the two 7200 RPM drives a RAID-1 and have some redundancy so > a single disk failure wouldn't lose all my data. then I'd start > buying more drives and a good RAID controller if I needed more > performance. Remember: disks are *cheap*. Spend an extra US$250 and buy a couple of 500GB drives for RAID 1. You don't mention what OS you'll use, but if you really need cheap then XP & Linux do sw RAID, and FreeBSD probably does too. - -- Ron Johnson, Jr. Jefferson LA USA %SYSTEM-F-FISH, my hovercraft is full of eels -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHSE6CS9HxQb37XmcRAhRTAKC4gFKymM0f46jKXpUX2NsUog4dOwCg00WP cDE5xB8Qm+3MDtri40HFrRs= =Vnb7 -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
