Re: Max effective number of CPUs that Postgresql can handle? - Mailing list pgsql-general

From Christoph Moench-Tegeder
Subject Re: Max effective number of CPUs that Postgresql can handle?
Date
Msg-id ZXDuj65ZYbMkh6Ap@sciurus.exwg.net
Whole thread Raw
In response to Max effective number of CPUs that Postgresql can handle?  (Ron Johnson <ronljohnsonjr@gmail.com>)
List pgsql-general
## Ron Johnson (ronljohnsonjr@gmail.com):

> Like the Subject says, is there any point of diminishing returns at which
> the Postmaster gets "too busy" to manage all the threads?

It is possible to use 3-digit cores (i.e. 128, maybe more) quite
efficiently. The rest of the system has to fit the amount of compute,
else you end up with an unbalanced system. Also, not every workload
can benefit from this kind of machine. (then: cost of redundancy,
etc.).
I believe there was a benchmark (actual numbers, not just marketing)
done by PostgresPro on a largish Power machine, but I can't find
that right now.

Regards,
Christoph

-- 
Spare Space.



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Delete Account
Next
From: Hans Schou
Date:
Subject: Re: Trainning and Certification