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.96) (envelope-from ) id 1vqr28-001rsN-1v for pgpool-general@arkaria.postgresql.org; Fri, 13 Feb 2026 11:08:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vqr27-00Dnf1-2r for pgpool-general@arkaria.postgresql.org; Fri, 13 Feb 2026 11:08:24 +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.96) (envelope-from ) id 1vqr27-00Dnet-29 for pgpool-general@lists.postgresql.org; Fri, 13 Feb 2026 11:08:24 +0000 Received: from mail-oa1-x2d.google.com ([2001:4860:4864:20::2d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vqr26-00000000TfZ-1zz6 for pgpool-general@lists.postgresql.org; Fri, 13 Feb 2026 11:08:24 +0000 Received: by mail-oa1-x2d.google.com with SMTP id 586e51a60fabf-40ea36b56b7so579288fac.3 for ; Fri, 13 Feb 2026 03:08:21 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1770980900; cv=none; d=google.com; s=arc-20240605; b=Xd2zsAAV/MO1D1YJ+XRva7MdFG5fGMdwh3umKwcm3tL21NgbFFS6XgC9Siu1/uWVF2 YdAoPh3+R98D6UxqOLZDJa8LXf+NVefUlCOt4vmO7om13INuinRSD6H4rIexsbqc+KNU 9sd2s6tCA02KCqW48iCjy5NYWa4bcjh28Q7r1KpzrxlzsT+1b9+TfkXDqlZZwcLiUluz vvsEeJz4UxdAwdaAaAiw161n5SbWR7yGw3Beb9pm5IVgrIA6GvL3ZcFVJPl6fuEvjH8D oPPqrS4ZAECaGsxkqdY9Dl0SOCQ4Lp7M7gnktI+P3jk2IdSuTGQTFi2fLtc2XXfJ5YuQ F2ow== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=39cS/wyJvzg6/ottZrcnPrRKCgYg+1HYV/FVVIzcfd0=; fh=O0GesjUlI9HfBCjNsD9P0ydof1JqrKWk5dBZEVdaDHA=; b=Szhwyoxz+66BoGgoiA7uFgPBDD1NNKrEI/MQV0hPwSxBkxufar9iKGzk0Q2+jSv1mq LTWXW1r/+Kf0T91CYsnuuiIOsuHABUR1hg2OkS13fNAOHK6W0lBjxuhU3dIqhCxtpOCx lVm8UzV/7+2y4BqVpuu+xxlxNTHVZFHav11cVCReXTHAjOj/v0OM0BfdLOTmEXtcS7eg VYYq+BWKcwdEJIqfLa+KIIQP2l8vv3LlDgWPy8nDoEbKJVG9Dtz+gVofkRUU8XZV5v7S 8h8dKBjoLxZQ6kGRc0AtjnJMFDlzlM8x3dChkrrjgLf7Lh5bKUhfG6e8ic09CEfRNNXB Dl/w==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1770980900; x=1771585700; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=39cS/wyJvzg6/ottZrcnPrRKCgYg+1HYV/FVVIzcfd0=; b=ODJmqxM+LbMrjCTw8AcdYVp4CiGhKGuS2Y0Y/Gqi98W41WKx+dQsTj9QfOviShKTbl zQKv4pekUuHOjJ3ZgH/dxhaSdTvtnOAYB5eF0IhsY7hMyYq6RMNQqzL3ghhUcNC2OfSV 4ig4kev2xpMRWdsZtjzCcxFaRZDQyRtYvAQuJqehbb533ZzEJdWdVQwD2wn5gHSlduxG QBNhEn5LFpPX6QNfaDe6j1fEF7NZacX/74IYIc8OE/MTO5KSFUHcDktQcEskUeJK4Izs 5M3IiP30QQov/oJGpQy7XDhWVQk/zaewgwDMXKpOM4CpbDl8aCsumFYzBW9aPUKD52y3 y0EA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1770980900; x=1771585700; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=39cS/wyJvzg6/ottZrcnPrRKCgYg+1HYV/FVVIzcfd0=; b=W/UPmopQ6x92fcow6bwuj9EIYmjCIwHl3nA1bK3N4M212HVULXIoMWTHssZpvA3Oac 8QblLfgjtW+vJLfsNIAtT1la8bBdL7gHMKy4zK1l9tkuvSh2YLMX+8aCw67an9d6SoJi uGvIx7HsafWTUW2pi2SQflNkFCC0PsgN9CqbhTGLHuIDD23un9b+1BzkIGCF3yOsbwxn 7w5hyR73Zu296HVq0QkbRPDfgXiuH8QdqubgPlVNpXyBLYD5ScznbNtHppff9OLS/a/M Ob65fZD9HKAWHHjxlhAeEDhnT6C2oNp+qo5JSaeWIr9WvhP+mVSdP+4W75CediHF8Tuf KX6A== X-Gm-Message-State: AOJu0YyMeT5APxB1lBJiuF60Sn+EaQQagGTCAK2g8QO7ke+fz4AYgXcJ WxIxQn2U214NVKLu66/xFajyz5c09oDrmilSB0JUop9oxYvAXJzjRuKl/ImGoEJV338pplRrxes R2U4TvZj0Ij+t4ZpTGAUhMcBse9JTkIYAVFoY X-Gm-Gg: AZuq6aL3orAgICK81EVYgBopxlxVFpGCmfEUF16MuXhrVAYWltlKgXV2pGJCLv6+idG +bLXFQ4CLljUqK3FBQrbIn8tpyxog8GFDcSbkvkZ6fAckcM/uTn+SzC2xGgZ7keqTtnOLJzRxAx i+xc8bUl4qr1IPsMIY43oYQvwgt/EajRCQHRT3AHI28BCGC28eP3lm6GnG7vK+sfiD9fMcn/ijI aePY7VhIXaRNQaGEt98YHmcvnPyB3bjthnUQHoP8CG191b1RUCa0NHTsaMbdMpUKh/EAkYR50bL XUR4RFoOnwdZKtP9 X-Received: by 2002:a05:6870:171b:b0:409:99bb:1eae with SMTP id 586e51a60fabf-40ef4054999mr764740fac.53.1770980899558; Fri, 13 Feb 2026 03:08:19 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Luca Ferrari Date: Fri, 13 Feb 2026 12:07:42 +0100 X-Gm-Features: AZwV_Qh2sbWaKa8eAdv-0I3EVUT_tPNibmBLYJV3gby9z0OkelPdAoJ1ZjcsrD8 Message-ID: Subject: Re: doubt about backend max_connections To: Koshino Taiki Cc: "pgpool-general@lists.postgresql.org" Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, Feb 12, 2026 at 2:17=E2=80=AFAM Koshino Taiki wrote: > > Hi, > > The value num_init_children =C3=97 max_pool applies per backend, > so every backend will receive max_pool =C3=97 num_init_children connectio= ns from Pgpool-II. > Thanks, it is clear now. > max_pool =C3=97 num_init_children =C3=97 2 =E2=89=A4 (max_connections =E2= =88=92 superuser_reserved_connections) > Because Pgpool-II opens additional connections to send cancel requests, t= he second formula is safer when query cancellation may occur. > I didn't know this, thank you very much for pointing out. Luca