From: | Josh Berkus <josh(at)agliodbs(dot)com> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Cc: | "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>, <alex(at)neteconomist(dot)com> |
Subject: | Re: which dual-CPU hardware/OS is fastest for PostgreSQL? |
Date: | 2005-01-14 17:36:08 |
Message-ID: | 200501140936.08654.josh@agliodbs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Merlin,
> I think the danger about SATA is that many SATA components are not
> server quality, so you have to be more careful about what you buy. For
> example, you can't just assume your SATA backplane has hot swap lights
> (got bit by this one myself, heh).
Yeah, that's my big problem with anything IDE. My personal experience of
failure rates for IDE drives, for example, is about 1 out of 10 fails in
service before it's a year old; SCSI has been more like 1 out of 50.
Also, while I've seen benchmarks like Escalade's, my real-world experience has
been that the full bi-directional r/w of SCSI means that it takes 2 SATA
drives to equal one SCSI drive in a heavy r/w application. However, ODSL is
all SCSI so I don't have any numbers to back that up.
But one of my clients needs a new docs server, so maybe I can give an Escalade
a spin.
--
Josh Berkus
Aglio Database Solutions
San Francisco
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Holovaty | 2005-01-14 18:32:12 | Index on a function and SELECT DISTINCT |
Previous Message | Merlin Moncure | 2005-01-14 17:22:50 | Re: which dual-CPU hardware/OS is fastest for PostgreSQL? |