| From: | Vivek Khera <vivek(at)khera(dot)org> |
|---|---|
| To: | Postgresql Performance <pgsql-performance(at)postgresql(dot)org> |
| Subject: | opinion on disk speed |
| Date: | 2005-12-08 16:52:17 |
| Message-ID: | 3E73FEF8-DD9D-4DF7-9BB1-C020A4186296@khera.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
I have a choice to make on a RAID enclosure:
14x 36GB 15kRPM ultra 320 SCSI drives
OR
12x 72GB 10kRPM ultra 320 SCSI drives
both would be configured into RAID 10 over two SCSI channels using a
megaraid 320-2x card.
My goal is speed. Either would provide more disk space than I would
need over the next two years.
The database does a good number of write transactions, and a decent
number of sequential scans over the whole DB (about 60GB including
indexes) for large reports.
My only concern is the 10kRPM vs 15kRPM. The advantage of the 10k
disks is that it would come from the same vendor as the systems to
which it will be connected, making procurement easier.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Amit V Shah | 2005-12-08 16:59:24 | Joining 2 tables with 300 million rows |
| Previous Message | Steve Poe | 2005-12-08 15:06:31 | Re: Disk tests for a new database server |