| From: | Achilleas Mantzios <a(dot)mantzios(at)cloud(dot)gatewaynet(dot)com> |
|---|---|
| To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
| Cc: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Mysterious connections to PostgreSQL (no statement) coming from pgbouncer (mode = transaction) |
| Date: | 2024-11-18 20:54:29 |
| Message-ID: | ee523c17-463d-4034-abcb-091924272720@cloud.gatewaynet.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Στις 18/11/24 22:07, ο/η David G. Johnston έγραψε:
> On Mon, Nov 18, 2024 at 1:03 PM Achilleas Mantzios
> <a(dot)mantzios(at)cloud(dot)gatewaynet(dot)com> wrote:
>
> We have been running pgbouncer (since 1.8) for quite some years,
> and today I realized I have connections to the DB from pgbouncer
> that don't do anything, do not execute any statement.
>
>
> Seems reasonable that a pooler would open connections to PostgreSQL to
> prime the pool even before any demand is seen. That way demand is
> immediately given a functioning connection.
Hello David,
I forgot to mention that in pgbouncer : min_pool_size=0 . So not reasonable.
>
> David J.
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2024-11-19 15:31:28 | Re: Broken behavior after minor update CVE-2024-10978 |
| Previous Message | David G. Johnston | 2024-11-18 20:07:12 | Re: Mysterious connections to PostgreSQL (no statement) coming from pgbouncer (mode = transaction) |