pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Max effective number of CPUs that Postgresql can handle?
2+ messages / 2 participants
[nested] [flat]

* Max effective number of CPUs that Postgresql can handle?
@ 2023-12-06 14:55  Ron Johnson <ronljohnsonjr@gmail.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Ron Johnson @ 2023-12-06 14:55 UTC (permalink / raw)
  To: pgsql-general

PG 9.6.24 on an ESX VM with nproc=32 and RAM=132GB (We'll be on 14.latest
hopefully by February.)

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

(I'm not in control of the stack's architecture, so "change
_insert_topic_here_" -- including connection pooling -- is not in the
cards.)

Thanks

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Max effective number of CPUs that Postgresql can handle?
@ 2023-12-06 21:58  Christoph Moench-Tegeder <cmt@burggraben.net>
  parent: Ron Johnson <ronljohnsonjr@gmail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Christoph Moench-Tegeder @ 2023-12-06 21:58 UTC (permalink / raw)
  To: Ron Johnson <ronljohnsonjr@gmail.com>; +Cc: 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.





^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2023-12-06 21:58 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-12-06 14:55 Max effective number of CPUs that Postgresql can handle? Ron Johnson <ronljohnsonjr@gmail.com>
2023-12-06 21:58 ` Christoph Moench-Tegeder <cmt@burggraben.net>

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