pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Christoph Moench-Tegeder <cmt@burggraben.net>
To: Ron Johnson <ronljohnsonjr@gmail.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
Subject: Re: Max effective number of CPUs that Postgresql can handle?
Date: Wed, 6 Dec 2023 22:58:39 +0100
Message-ID: <ZXDuj65ZYbMkh6Ap@sciurus.exwg.net> (raw)
In-Reply-To: <CANzqJaBaXRw=mvfV_1e6fx8zN-RgZRTRNyjhvTodL5BdKOsahQ@mail.gmail.com>
References: <CANzqJaBaXRw=mvfV_1e6fx8zN-RgZRTRNyjhvTodL5BdKOsahQ@mail.gmail.com>

## 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.





view thread (2+ messages)

Message-ID: <ZXDuj65ZYbMkh6Ap@sciurus.exwg.net>
Permalink:  ../ZXDuj65ZYbMkh6Ap@sciurus.exwg.net/
Also on:    postgresql.org/message-id/ZXDuj65ZYbMkh6Ap@sciurus.exwg.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-general@postgresql.org
  Cc: cmt@burggraben.net, ronljohnsonjr@gmail.com
  Subject: Re: Max effective number of CPUs that Postgresql can handle?
  In-Reply-To: <ZXDuj65ZYbMkh6Ap@sciurus.exwg.net>
  References: <CANzqJaBaXRw=mvfV_1e6fx8zN-RgZRTRNyjhvTodL5BdKOsahQ@mail.gmail.com> <ZXDuj65ZYbMkh6Ap@sciurus.exwg.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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