amka put forth on 12/15/2009 3:08 PM: > Le mardi 15 décembre 2009 à 10:34 -0800, Kelly Clowers a écrit : >> On Tue, Dec 15, 2009 at 10:14, Camaleón <noela...@gmail.com> wrote: >>> On Tue, 15 Dec 2009 09:58:02 -0800, Kelly Clowers wrote: >>> >>>> On Mon, Dec 14, 2009 at 14:22, Andrew M.A. Cater >>>>> Get good quality memory (possibly ECC memory if you can) and you'll >>>>> have a workhorse for a long period of time. >>>> Since I doubt he is running a DB that big just for fun, I would say ECC >>>> RAM is mandatory. In fact, every time I look up the error rates for RAM, >>>> I wonder why consumer class RAM isn't ECC. >>> I have read the latest Intel chipsets (Core i7 - Bloomfield) do not allow >>> ECC RAM. >>> >>> Quite rare :-? >> Yes, I think on the Intel side you have to go with a Xeon to get ECC. >> At least some Phenoms and such support ECC though. > > Yes, it does, but not registred ECC, isn't it ? I think it's better > both. > > Unfortunatly, it seems that only the Opterons 2xxx can work with this.
Time to stop jaw jacking on this. Keep your current PC and buy this for your db server. It's got everything you want and need at a decent used price, including ECC memory: http://cgi.ebay.com/HP-Proliant-DL585-Quad-AMD-852-2-6Ghz-8GBRam-Server_W0QQitemZ370306750655QQcmdZViewItemQQptZCOMP_EN_Servers?hash=item56380098bf Enter the SmartArray BIOS utility, wipe the current drive config, create a RAID 10 set. From the Debian installer, on the resulting 146GB RAID 10 disk, create a 100MB partition for /boot, a 4GB swap partition, and a 20GB partition for /root, and create a ~120GB partition from the remaining space and mount it as /db or /postgre or something. Or if you really know what you're doing slice it up as you see fit. Since you're after database performance I recommended RAID 10. If 146GB isn't enough space, you can go RAID 5 instead and gain another 73GB of usable space, though your performance and data integrity will suffer somewhat. Given the SmartArray controller has 64MB cache memory and these are 10,000 RPM disks, you can probably go RAID 5 and still have excellent performance for your applications. That'll give you a disk of about 220GB instead of ~146GB. All this for somewhere less than $1000 USD including international shipping. Only downside is it would seem this used unit has been dropped once or otherwise suffered impact damage. As always, buyer beware when acquiring used items from Ebay. Seller has an excellent rating, so it probably works fine. Anyway, a good option to consider given your needs. -- Stan -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
