Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rAzuq-0092Jk-EY for pgsql-general@arkaria.postgresql.org; Wed, 06 Dec 2023 21:58:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rAzup-00CqWi-2f for pgsql-general@arkaria.postgresql.org; Wed, 06 Dec 2023 21:58:47 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rAzuo-00CqWX-Nn for pgsql-general@lists.postgresql.org; Wed, 06 Dec 2023 21:58:46 +0000 Received: from smtp.burggraben.net ([88.198.69.140]) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rAzuk-00992A-O0 for pgsql-general@postgresql.org; Wed, 06 Dec 2023 21:58:45 +0000 Received: from sciurus.exwg.net (p57a63461.dip0.t-ipconnect.de [87.166.52.97]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client CN "sciurus.exwg.net", Issuer "R3" (not verified)) by smtp.burggraben.net (Postfix) with ESMTPS id 2A689C00317; Wed, 6 Dec 2023 22:58:40 +0100 (CET) Received: by sciurus.exwg.net (Postfix, from userid 1000) id CD9F14343C9D; Wed, 6 Dec 2023 22:58:39 +0100 (CET) Date: Wed, 6 Dec 2023 22:58:39 +0100 From: Christoph Moench-Tegeder To: Ron Johnson Cc: pgsql-general Subject: Re: Max effective number of CPUs that Postgresql can handle? Message-ID: References: MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline In-Reply-To: User-Agent: Mutt/2.2.12 (2023-09-09) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ## 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.