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 1vpNwj-0077zh-2f for pgpool-general@arkaria.postgresql.org; Mon, 09 Feb 2026 09:52:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vpNwh-009zO1-0E for pgpool-general@arkaria.postgresql.org; Mon, 09 Feb 2026 09:52:42 +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.96) (envelope-from ) id 1vpNwg-009zNr-2f for pgpool-general@lists.postgresql.org; Mon, 09 Feb 2026 09:52:42 +0000 Received: from mail-ot1-x32e.google.com ([2607:f8b0:4864:20::32e]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vpNwe-00000001Frj-2h6Z for pgpool-general@lists.postgresql.org; Mon, 09 Feb 2026 09:52:41 +0000 Received: by mail-ot1-x32e.google.com with SMTP id 46e09a7af769-7d1890f5cafso939272a34.1 for ; Mon, 09 Feb 2026 01:52:40 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1770630759; cv=none; d=google.com; s=arc-20240605; b=O/42osdFVG6HzNHazlYuyV2qdgmKHmFxwKo894zCmzu/yPN03CCgSyvY6FPJ2YwkhF zMh0MGllLjtvFyqPAiyVu+fZdao1kxvlzgSn/vJyDqQPKkhTjTRU6+ijINB2Cvs6ZB3I Nyc6sAJPI8KJzVB8Tzc7Mpcc4W/4kZ7oNuZJDbmYlcna4/wFAa7RabJqacwG96yl0rYv dXHOR3M4SagY8nBGCHLI4dZShsFrHW92NT4gUGvF6fzmZyKkJ53k3CEztnxrYmDsqMmu NQVeALl/cRjjLOFshyGqaxN9v2Ari3ubUpfxBIcmxs7wTqqcyoYuPhhrDVs19oTzaHdg mgWQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=to:subject:message-id:date:from:mime-version:dkim-signature; bh=DFO+KnX2ckK0x5K08u1W3gcNXAgbITrQsJ5s+QoY8tM=; fh=QXRwOxoT5ye2/huCVtbLLQOHdouN+t+tIhYvHNj1+CE=; b=HrAYUheWIA7bQQTQaJBbnoo1/voLL1Kg/UknbvmCYffc82xW5RVHva0t7w98JMFtPK XpYp0PcKLtWCImzzIbignR6Nc4PSHlQc1wbD1s6REbrWLpD8Vk3o94j0vXEv2/TIj+94 Q9NuVyaLJEDSs59rxAIzXMK0iwPblrVaw38y2AFmFNgxVn1eecyt86ibibK4jU1LLfBo AVxFAzx6HNQNxpyJ8BXDHQowHd9veo7stV6ZtCSjdEHY3NQDQhRw8rFxWoktZaiHWR2T 966LqF1Oaq1i+D7CXc6fAx+iXWwYzjlsyvjvFVXR5Vzm/wR6VG5PJK7GQJNPOBqplIhR dvcQ==; 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=1770630759; x=1771235559; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=DFO+KnX2ckK0x5K08u1W3gcNXAgbITrQsJ5s+QoY8tM=; b=kYZ2/QqE91Tl6jIT7o44h2VNKuvLhQ4+4zFEj6I5mRSF6wWHMQTvARiY3S894jeDnb 707jLxaGN01n+aNdM+wT1SkOwxOs9e+q9I0+KqhOqtYV+7wNPnnIQnKRLeNSnRCEhefM 4+Jt3wB4EfOOPQC8Flp0rgsshVWDpk1s17pbTe7FPG0gT4OQGq6oMmb9jHzqpRNsZIue J96TE5Ipk5/4eN3RD5VGPlHVCVkZRvzOgtaVopsrNu8XObL/gEqvGCWuSMZkhx3jaPay Ot2qzjb0mz6EHmtZPTLBmRCv4cFzyKR3ipuCfWBdXJOv7xRu8SHKOVBOfIsM57+YLAZa cFBw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1770630759; x=1771235559; h=to:subject:message-id:date:from:mime-version:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=DFO+KnX2ckK0x5K08u1W3gcNXAgbITrQsJ5s+QoY8tM=; b=tKDhe9LhxL6CDrU/ZJrCsLMO5Ie0J5P8tYTVE1cDlhV6CKFXMlJ13mL/UHL2KcXOkt SeBMlyrTguNM3E/4P45tSN5A96mrD0fsRDc02XofKFmoXlBwX5C+PvLfSJBdej33Z7JT xckIb35vY9VwZ0t1Nu8EgWfvNY1hX1E83RdNTyz6mOk3RAYawbfO98MhYsVxqkWlTOcf KUVbqXMtkfdl3Cnm8j4n5x/27wcr2SIXCUMw/WDbWDBve3h/MWRNhOIC+MDF6Q3+mX4r rdiRL5QA1oCtZIDGjp27Gwm5yhUtJ00Kw2VruWUcDj28y+7IUFFleaypdJ2pEwJhdH92 ztgQ== X-Gm-Message-State: AOJu0Yw9EDMYT/i1j5lhs5V+n/zxMBP8RGK384vecB+CDhRCH8lkzCFi TG6CUnTwFT/3r06K5SBBSnststGTE60CVXoSuFH9lm/gxU8QeK+9jL4navReg4FKdkF8sfXMEn/ TMcjQTklVtr9+Am+fqB1zW9adcu4Fky6/vZfUZGQ= X-Gm-Gg: AZuq6aK+/zXfpscewk+ss3jRt5FGZxVJnpaoS/3hB3OypS/m4uZQNLlqTU8BoyDxts0 JbzhfUFhrZTaoa7I6m6AK9qwVQLw8AuNXvHnCkwcbsZoPOER74MWE0UhOuZfS/QF4krM3cRX9vY CDSX9FqGNkKTWn5jiI8bQAStSuGQdzonZsLDuJr8ZvObyR9gITGxi89+m5tUWGqTukONv11amrX OI2AKqrHzxNwkOf/8zwPRnwgqd5gardFOWU2O3JiB5U8nSLKab70aOsv6a1paiZa7BjkQ== X-Received: by 2002:a05:6830:6ae9:b0:7cf:e57f:df02 with SMTP id 46e09a7af769-7d46467e8b7mr6099582a34.26.1770630759208; Mon, 09 Feb 2026 01:52:39 -0800 (PST) MIME-Version: 1.0 From: Luca Ferrari Date: Mon, 9 Feb 2026 10:52:03 +0100 X-Gm-Features: AZwV_QhzTOYXag32u7GqIUZj0PylgF_wPTQRPOhpNfWrKvKGESli8WuG3ZiaFHg Message-ID: Subject: doubt about backend max_connections To: pgpool-general@lists.postgresql.org Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi all, I've a doubt about configuring max_pool and num_init_children and, subsequently, PostgreSQL max_connections. In there is this sentence "Please be aware that the number of connections from Pgpool-II processes to the backends may reach num_init_children * max_pool in total. " regarding max_pool. Now, my doubt is: does this apply to all the backends (i.e., every backend will receive a max_pool * num_init_children connections or dows it apply "cluster wise", so every node will receive num_init_childre * max_pool * num_of_backends_in_pgpool? Seems to me the former, but I want to be sure. Thansk, Luca