In a perhaps fitting compromise, I have decide to go with a hybrid
solution:
8*73GB 15k SAS drives hooked up to Adaptec 4800SAS
PLUS
6*150GB SATA II drives hooked up to mobo (for now)
All wrapped in a 16bay 3U server. My reasoning is that the extra SATA
drives are practically free compared to the rest of the system (since
the mobo has 6 onboard connectors). I plan on putting the pg_xlog &
operating system on the sata drives and the tables/indices on the SAS
drives, although I might not use the sata drives for the xlog if
they dont pan out perf-wise. I plan on getting the battery backed
module for the adaptec (72 hours of charge time).
Thanks to everyone for the valuable input. I hope i can do you all
proud with the setup and postgres.conf optimizations.
-jay
On Apr 4, 2007, at 1:48 PM, Carlos Moreno wrote:
>
>> Problem is :), you can purchase SATA Enterprise Drives.
>
> Problem???? I would have thought that was a good thing!!! ;-)
>
> Carlos
> --
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
>
> http://www.postgresql.org/about/donate