| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | Tom Laudeman <twl8n(at)virginia(dot)edu>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Tuning to speed select |
| Date: | 2006-08-11 16:40:56 |
| Message-ID: | 44DCB318.8040400@commandprompt.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Roman Neuhauser wrote:
> # twl8n(at)virginia(dot)edu / 2006-08-11 10:12:40 -0400:
>> I think my Dell Precision 650 has SATA on the motherboard. The boss says
>> I can order one drive, so what should I get? How much faster is RAID 0+1
>> than a single drive?
If you can order one drive, get a drive that is twice the size of what
you have. Use one partition of that drive to create a raid 1. Use the
other partition to push off nightly rsyncs :)
Sincerely,
Joshua D. Drake
>
> You need 4 disks for 0+1 (or 1+0, also called 10).
>
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martijn van Oosterhout | 2006-08-11 16:51:24 | Re: VACUUM VERBOSE output to STDERR |
| Previous Message | Ioannis Theoharis | 2006-08-11 16:35:29 | Add column |