pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedAMD vs Intel
3+ messages / 3 participants
[nested] [flat]
* AMD vs Intel
@ 2013-09-04 09:01 Johan Loubser <johanl@sun.ac.za>
2013-09-04 10:41 ` Re: AMD vs Intel Albe Laurenz <laurenz.albe@wien.gv.at>
2013-09-04 13:14 ` Re: AMD vs Intel David Boreham <david_list@boreham.org>
0 siblings, 2 replies; 3+ messages in thread
From: Johan Loubser @ 2013-09-04 09:01 UTC (permalink / raw)
To: pgsql-performance
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 wie dit geadresseer is. Indien u nie die bedoelde ontvanger is nie, word u hiermee in kennis gestel dat u hierdie dokument geensins mag gebruik, versprei of kopieer nie. Stel ook asseblief die sender onmiddellik per telefoon in kennis en vee die e-pos uit. Die Universiteit aanvaar nie aanspreeklikheid vir enige skade, verlies of uitgawe wat voortspruit uit hierdie 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 whom it is addressed. If you are not the intended recipient, you are notified that you may not use, distribute or copy this document in any manner whatsoever. Kindly also notify the sender immediately by telephone, and delete the e-mail. The University does not accept liability for any damage, loss or expense arising from this e-mail and/or accessing any files attached to this e-mail.
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: AMD vs Intel
2013-09-04 09:01 AMD vs Intel Johan Loubser <johanl@sun.ac.za>
@ 2013-09-04 10:41 ` Albe Laurenz <laurenz.albe@wien.gv.at>
1 sibling, 0 replies; 3+ messages in thread
From: Albe Laurenz @ 2013-09-04 10:41 UTC (permalink / raw)
To: Johan Loubser *EXTERN* <johanl@sun.ac.za>; pgsql-performance
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
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: AMD vs Intel
2013-09-04 09:01 AMD vs Intel Johan Loubser <johanl@sun.ac.za>
@ 2013-09-04 13:14 ` David Boreham <david_list@boreham.org>
1 sibling, 0 replies; 3+ messages in thread
From: David Boreham @ 2013-09-04 13:14 UTC (permalink / raw)
To: pgsql-performance
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.
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2013-09-04 13:14 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-09-04 09:01 AMD vs Intel Johan Loubser <johanl@sun.ac.za>
2013-09-04 10:41 ` Albe Laurenz <laurenz.albe@wien.gv.at>
2013-09-04 13:14 ` David Boreham <david_list@boreham.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox