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 1sK0un-007rv4-It for pgsql-hackers@arkaria.postgresql.org; Wed, 19 Jun 2024 19:24:17 +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 1sK0uk-005YBx-MY for pgsql-hackers@arkaria.postgresql.org; Wed, 19 Jun 2024 19:24:15 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sK0uk-005YBp-A4 for pgsql-hackers@lists.postgresql.org; Wed, 19 Jun 2024 19:24:15 +0000 Received: from mail-il1-x136.google.com ([2607:f8b0:4864:20::136]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sK0ui-002WMU-Ui for pgsql-hackers@postgresql.org; Wed, 19 Jun 2024 19:24:14 +0000 Received: by mail-il1-x136.google.com with SMTP id e9e14a558f8ab-36da84df7adso543985ab.1 for ; Wed, 19 Jun 2024 12:24:12 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1718825051; x=1719429851; darn=postgresql.org; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=bF5pRuBGo1u3PZ82Lv71GKlpvXqYX22xEwBlAGumsQc=; b=iuYjQT33ce9d3jSxnzx3Xn1qn2sNeMHsJezF7hI59cujzbfyw50eelQgqJX30YTZFV ACQZEJErZ4kM98RaeiXsQlP2gzpEg8daE2fToOri89SDiTNAQoNdZACQCXAwmZMVtJ3O yye3Pq+QN9nwyqddd0GkkPkfi81M0qDFRfYGMqiTMC/jbDNfevXhY7TAR1ITosS1V7EV ECdiSmO4wqBCW7/qRy0nyyYsO9Rqn+/QVnDRCE84V+oZ81o98kNqs0ZBkgSZJSbmwZQw iX42Rs8HmTGhqKK0j/GtDNmXy4ObQXWuTCt2TDsoshc2jDGLKdnBR7TLoQMGI6xVKLgt qS8g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1718825051; x=1719429851; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=bF5pRuBGo1u3PZ82Lv71GKlpvXqYX22xEwBlAGumsQc=; b=hTDkYjtwnJKfYruTWwMYMNctls/M9XEcwDhgTi6h8XMfBDvXPcXr+jk1siNTGTJu0P PEMnh93Q7YerIA5IlJnIDPgb1RPj+o0acZvu6WWLzebCqU0lEydvfmja7B16q+eVqEva x7v/a35kfEBsPHn2YHf7F5v1z7HJvbA62QgPBTNh7HJZ8mhQ5mbPR+9sldMJR73NBSc8 XTPkNiCOt94YgyhDlov8KQp5Ci+L0TIxnsTaH4dddte/z/3uZRfn0Hwqz9o3zkELlTSS ULX1T7v3WlQ5aEdp5XryCRe5xxVKJGqkFjWVxJxWwA2+EE4Lu4LKJxSYvkDJMwJpQna7 KRyQ== X-Gm-Message-State: AOJu0YwNe8IRBJtX0mfI3Jx/tD6eWo8NQ0VAiz6PeAp94ty6rhfGIIWq wmogSjbBHr2jpcIlPNM1sbynaQUVSvFcgZd4kv6j++4WfTMGyNhaf+2EhpC5 X-Google-Smtp-Source: AGHT+IFAKRZ+eaQ5wDT55pWrV56+N8UT0TLqkzebDHYEFjUgvG/TAeNf4k1rnQKMxpFFwG/ML3G6Xg== X-Received: by 2002:a05:6e02:1a49:b0:375:ac54:b2ad with SMTP id e9e14a558f8ab-3761d0fb022mr18203135ab.9.1718825050625; Wed, 19 Jun 2024 12:24:10 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id e9e14a558f8ab-375d895bc9csm28013115ab.75.2024.06.19.12.24.10 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 19 Jun 2024 12:24:10 -0700 (PDT) Date: Wed, 19 Jun 2024 14:24:08 -0500 From: Nathan Bossart To: Tom Lane Cc: pgsql-hackers@postgresql.org Subject: Re: remove check hooks for GUCs that contribute to MaxBackends Message-ID: References: <148099.1718824456@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <148099.1718824456@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, Jun 19, 2024 at 03:14:16PM -0400, Tom Lane wrote: > Nathan Bossart writes: >> The attached patch removes these hooks and enhances the error message to >> look like this: > >> FATAL: too many backends configured >> DETAIL: "max_connections" (262100) plus "autovacuum_max_workers" (3) plus "max_worker_processes" (8) plus "max_wal_senders" (10000) must be less than 262142. > > BTW, I suggest writing it as "too many server processes configured", > or perhaps "too many server processes required". "Backend" is too > much of an insider term. Will do, thanks for reviewing. -- nathan