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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
