@Nicola, while I'm glad you got further help.. I was asking myself it you maybe
missed my answer to your question? (mail from 10/10/2018 at 15:31)
https://www.postgresql.org/message-id/a22f8385-2a49-30a7-b1d2-fc743c2f3245%40portavita.eu
regards,
fabio pardi
On 16/10/2018 14:12, Nicola Contu
11:12 AM
To: martin.marq...@2ndquadrant.com
Cc: Scot Kreienkamp ;
pgsql-general@lists.postgresql.org; Alessandro Aste
Subject: Re: Pgbouncer discard all
2492534808 | dev| 7355 | 1833427130 | pgbouncer |
| 10.151.2.145 | | 60570 | 2018
El 16/10/18 a las 12:12, Nicola Contu escribió:
> 2492534808 | dev | 7355 | 1833427130 | pgbouncer |
> | 10.151.2.145 | | 60570 |
> 2018-10-16 14:13:05.151015+00 | |
> 2018-10-16 15:10:40.309993+00 | 2018-10-1
2492534808 | dev| 7355 | 1833427130 | pgbouncer |
| 10.151.2.145 | | 60570 | 2018-10-16
14:13:05.151015+00 | | 2018-10-16
15:10:40.309993+00 | 2018-10-16 15:10:40.310038+00 | Client
| ClientRead | idle |
El 16/10/18 a las 09:59, Scot Kreienkamp escribió:
> Are you sure they’re actually waiting? Don’t forget 10.5 will show the
> last query executed even if the connection is idle. I believe discard
> all would be the last command the pgbouncer would send to the database
> when the client is done as
, Michigan 48162 | Office: 734-384-6403 | | Mobile:
7349151444 | Email: scot.kreienk...@la-z-boy.com
From: Nicola Contu [mailto:nicola.co...@gmail.com]
Sent: Tuesday, October 16, 2018 8:12 AM
To: pgsql-general@lists.postgresql.org
Cc: Alessandro Aste
Subject: Re: Pgbouncer discard all
Hello,
is this
Hello,
is this normal? can anyone help?
Thanks a lot for your help in advance.
Nicola
Il giorno mer 10 ott 2018 alle ore 17:03 Nicola Contu <
nicola.co...@gmail.com> ha scritto:
> Hello,
> we are running pgbouncer 1.9.1 connected to postgres 10.5
>
> Sometimes we are seeing a lot of waiting con
Hi Nicola,
I am of the impression that the problem of having waiting clients does not
depend from server_idle_timeout
How is the load on both ends of pgbouncer? High? Low? No activity? A lot of
content switch perhaps?
I think that a pool_size of 120 is very high, unless you have an XXL databas
Hello,
we are running pgbouncer 1.9.1 connected to postgres 10.5
Sometimes we are seeing a lot of waiting connections with this query :
DISCARD ALL
This is our pgbouncer config :
[databases]
dev = host=10.10.10.1 port=5432 dbname=dev auth_user=pgbouncer pool_size=120
[pgbouncer]
listen_port =
