Re: Disk arrangement in a cheap server

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 11/24/07 09:12, Scott Marlowe wrote:
> On Nov 24, 2007 5:09 AM, Clodoaldo <clodoaldo(dot)pinto(dot)neto(at)gmail(dot)com> 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-----