Clodoaldo asked:
> 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.
>
> There will be 4 GB of memory, Fedora 8 and Postgresql 8.3.
>
You haven't told us much (enough?).
What sort of work load ? (OLTP ? Data Warehouse ? Massive loads and the lots of read-only transactions ?)
How valuable is your data ? If it is worth much at all lean toward an option that maximizes safety (and plan on a good backup strategy, tested and all that).
In general more spindles are faster, but it depends on the actual work load.
Greg Williamson
Senior DBA
GlobeXplorer LLC, a DigitalGlobe company
Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information and must be protected in accordance with those provisions. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
(My corporate masters made me say this.)