Обсуждение: AMD vs Intel
I am tasked with getting specs for a postgres database server for the core purpose of running moodle at our university. The main question is at the moment is 12core AMD or 6/8core (E Series) INTEL. What would be the most in portend metric in planning an enterprise level server for moodle. -- Johan Loubser (021) 8084036 Informasie Tegnologie University of Stellenbosch E-pos vrywaringsklousule Hierdie e-pos mag vertroulike inligting bevat en mag regtens geprivilegeerd wees en is slegs bedoel vir die persoon aan wiedit geadresseer is. Indien u nie die bedoelde ontvanger is nie, word u hiermee in kennis gestel dat u hierdie dokumentgeensins mag gebruik, versprei of kopieer nie. Stel ook asseblief die sender onmiddellik per telefoon in kennis envee die e-pos uit. Die Universiteit aanvaar nie aanspreeklikheid vir enige skade, verlies of uitgawe wat voortspruit uithierdie e-pos en/of die oopmaak van enige lês aangeheg by hierdie e-pos nie. E-mail disclaimer This e-mail may contain confidential information and may be legally privileged and is intended only for the person to whomit is addressed. If you are not the intended recipient, you are notified that you may not use, distribute or copy thisdocument in any manner whatsoever. Kindly also notify the sender immediately by telephone, and delete the e-mail. TheUniversity does not accept liability for any damage, loss or expense arising from this e-mail and/or accessing any filesattached to this e-mail.
Johan Loubser wrote: > I am tasked with getting specs for a postgres database server for the > core purpose of running moodle at our university. > The main question is at the moment is 12core AMD or 6/8core (E Series) > INTEL. > > What would be the most in portend metric in planning an enterprise level > server for moodle. I know too little about hardware to give an answer, but there are a few things to consider: - The faster each individual core is, the faster an individual query will be processed (in-memory sorting, hash tables etc.). - More cores will help concurrency, but maybe not a lot: often it is I/O bandwidth that is the limiting factor for concurrency. I think the best thing would be to estimate the amount of data, concurrent users and operations per second you expect. There is the excellent book "PostgreSQL High Performance" by Greg Smith that I would recommend to read. Yours, Laurenz Albe
On 9/4/2013 3:01 AM, Johan Loubser wrote: > I am tasked with getting specs for a postgres database server for the > core purpose of running moodle at our university. > The main question is at the moment is 12core AMD or 6/8core (E Series) > INTEL. > > What would be the most in portend metric in planning an enterprise > level server for moodle. > The only way to be sure is to test your workload on the two different machines. That said, we moved from AMD to Intel E series Xeon a year ago. We were using 8-core AMD devices not 12, and switched to 6-core Intel. The Intel devices were more attractive due to their (much) higher single-core performance. Another factor was a history of hardware bugs in the support chips used on AMD systems that we haven't generally seen with Intel. So all other things being equal, Intel brings less hassle, in my experience.