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

2023-12-06 Thread Christoph Moench-Tegeder
## Ron Johnson (ronljohnso...@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

Max effective number of CPUs that Postgresql can handle?

2023-12-06 Thread Ron Johnson
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