Re: Max effective number of CPUs that Postgresql can handle?

From: Christoph Moench-Tegeder <cmt(at)burggraben(dot)net>
To: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Max effective number of CPUs that Postgresql can handle?
Date: 2023-12-06 21:58:39
Message-ID: ZXDuj65ZYbMkh6Ap@sciurus.exwg.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

## Ron Johnson (ronljohnsonjr(at)gmail(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Hans Schou 2023-12-06 22:04:10 Re: Trainning and Certification
Previous Message Sehrope Sarkuni 2023-12-06 21:42:11 Re: Emitting JSON to file using COPY TO