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 1vitud-0011yV-2y for pgsql-general@arkaria.postgresql.org; Thu, 22 Jan 2026 12:35:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vitud-00D2U2-06 for pgsql-general@arkaria.postgresql.org; Thu, 22 Jan 2026 12:35:47 +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 1vituc-00D2Tt-2I for pgsql-general@lists.postgresql.org; Thu, 22 Jan 2026 12:35:47 +0000 Received: from mail-pj1-x102a.google.com ([2607:f8b0:4864:20::102a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vitua-001u01-2V for pgsql-general@postgresql.org; Thu, 22 Jan 2026 12:35:46 +0000 Received: by mail-pj1-x102a.google.com with SMTP id 98e67ed59e1d1-352c414bbbeso1485012a91.0 for ; Thu, 22 Jan 2026 04:35:44 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1769085343; cv=none; d=google.com; s=arc-20240605; b=V4zp3qNfoCMs1XKpG+4bdljbBy6QuGTIUglND/Uew7XBvLp46cffZATu/K8xLdiDG9 PosrpZLBYkAC6Av8T+zXjL8B0k2zO47cahgFBe9Vt9jm12AYz2c4InidJ8eiPjg8lkRd hDoD5Jd14xX4Z0rl5QlgB/nkvwM5CawiiS/WPUBGPYwWQQf3mHHZ+A38bc8xSOQmqS/n +/W+lOo9RVvc0XRdCpw7ka3UpgCvyMOYZpbU73hyms/MHUKshVAhCFq+Cct/Jm/HTpjV +ACepeSuEG+uqfDV5N3fR/na9braopx3hZNDEdxSua9ma0vplR94WNt+3GFUVYQPZ8MS 9Yvw== 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=F1WEx2GV1U+n9DVoCtt/47jDY+g9i+fLruoFNgzz3g4=; fh=qDKhmZZwk02KsKWIk1HxqfXWbdkUUA+FsDakiBO/tH4=; b=dfrqZ4BrpgSwS4MnWbQ1NVSF9XJwMm6MGpKbglfLjW/3EpKnqlzK7fDp2ZXwg0XvxZ Dzr8Twx9kzh40Djw6ArZxciIoAajZbI9dkJGZkC6xu77aj5lwWfXF7et3QnvycH3HBbQ gOXUnNs4pQYwxdkGy3wYkB8wM/w7B6vi2DvS1N6vHnigjablUYNFY+VznXbxXymx9p3c yRmnwZN2q9qO7F+fVeLsN5X29hQ9RViPhyghSqSHO+oT8a7tqhriDr0BK1fOwQDts8yN JUg0nDd2d8vYtPkBNT+9Ts6b80gj1lAS2SFMMGavObh0WxeiFKQCp7lcH91jkqOFCsyJ YYcw==; darn=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=1769085343; x=1769690143; darn=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=F1WEx2GV1U+n9DVoCtt/47jDY+g9i+fLruoFNgzz3g4=; b=iB8RpbZ/Rj7yS8Kp+rwjibcID508/PvchTuNY0bpn2cIUEwKpzl23msw1guOZ/z1B/ dTAoD+P4bzBHGZCM4qRs9b5tlEkc5OAzdbVvsCqOj6JzsC6gZRUgqy5MLuIe7EfR4Tbu H2ht/TvA5tsLnwlvmqFsItVThyGBYgHOhr0SHl+eJrLHQxGzWoudcro3g0G5IHTPnsMg WvanyodcI1fSZuO8X88QbRuad0vzeYZ3fU5i5LmdPz7tdgs+bD9A0MFONZkaV5cbHpvN Z6zFVO8etng/xSKk5SSJ3xdHHHfmpkfTc5XgXSq3nK7hU77WdVFw1O/mZa4qJWmDWDAs d30Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1769085343; x=1769690143; 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=F1WEx2GV1U+n9DVoCtt/47jDY+g9i+fLruoFNgzz3g4=; b=sBfxgu6rJsR7LWabinkZKX/+zD5mpZWQRN1u5rFB1ZAmTHYwHRQFcR4jM9f46a63Z1 BJ23TYzmC8bdIqPC9EZq5A1+UHs5/mPuFaV3XTM4GH5oVG2xorniUUz8NZ8dGEJj+qan VvBbF+jWvxCQFrki+y0vRIuOWLI/Yu2IRKSxCbPoBg8SKys8SNkPe/uuqzZ5Hz2OiI2m K/frzi8U0Tr027CLyVzJRy5GAwSdEpvUwHpvaJU70nHM7SgRfoASrIxLcWweQDceqkHy 08bjq0Afd1xrCEgHM53ht8v853mrfU4aJXCdORN/O9wJBidceHMSmy+xxWzcOKbvEuG1 xo5w== X-Gm-Message-State: AOJu0Yz6173f/OlHK9ZuHNVr3fkwFV6+KkYP8XBmST+deOoBS4csZbBK 5pWm46XM4tG6cNENARfUC1S8e5iPAhmAR0frZB2U9hKnth9m/+LQlDuq5IrdMoNevcBYE1d36Ta OXJcQMpNbkaAietoIcAkCpg5KPpCgsrI= X-Gm-Gg: AZuq6aIze7kpa2w5CUFu8j9ZkuSSX87+i8bH6JNMRujWTZDF1/Sjb9sO+DUUq8mlzF4 dw+Pg1cxgmdF5dQ0QkXgIlmMTp3r/Ngh5UFnyF958F7xXEAIJAlYoD5nXbufC4JvDnrUDtjUXLU ogIZ+le8N+ho13RK9Ka0aB8qB4enjqWA5Zqp00yJDkNbCkw2UPl1FPyCTj6Hv1xZ0zoxTVNDS6b xqtUgG7vHCbopC/Jfb5O5/f/5Yf48/6z+7XIr9KwGfvu4tetn1q4VdayuD9mPwFb1+djCPcEw== X-Received: by 2002:a17:90b:35d2:b0:343:e692:f8d7 with SMTP id 98e67ed59e1d1-353354a8e5fmr2438591a91.11.1769085342608; Thu, 22 Jan 2026 04:35:42 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Dominique Devienne Date: Thu, 22 Jan 2026 13:35:30 +0100 X-Gm-Features: AZwV_QgtiE9xnqwC6dA2nSJEg9yTUh7sWOzyf-QTSU43g9Hm7fozfq7dxP8fLok Message-ID: Subject: Re: Pgbouncer performance query To: KK CHN Cc: pgsql-general 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, Jan 22, 2026 at 1:29=E2=80=AFPM KK CHN wrote: > I agree when I have increased the concurrent connections to 300 (pgben= ch -c 300 ) then Direct hit on DB server fails with Error too many client= s as follows Just increase max_connections then: https://www.postgresql.org/docs/current/runtime-config-connection.html#GUC-= MAX-CONNECTIONS Sounds like you should stick to direct PostgeSQL access, if pgBouncer makes it 10x slower :). --DD