Max effective number of CPUs that Postgresql can handle?

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Max effective number of CPUs that Postgresql can handle?
Date: 2023-12-06 14:55:52
Message-ID: CANzqJaBaXRw=mvfV_1e6fx8zN-RgZRTRNyjhvTodL5BdKOsahQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2023-12-06 14:58:38 Re: GIN INdex is not used with && operator for a text array index
Previous Message Ron Johnson 2023-12-06 14:43:27 Re: Store PDF files in PostgreDB