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.contu@xxxxxxxxx> ha scritto:
Hello,we are running pgbouncer 1.9.1 connected to postgres 10.5Sometimes we are seeing a lot of waiting connections with this query :DISCARD ALLThis is our pgbouncer config :[databases]dev = host=10.10.10.1 port=5432 dbname=dev auth_user=pgbouncer pool_size=120[pgbouncer]listen_port = 6543listen_addr = *auth_type = md5auth_file = /etc/pgbouncer/users.txtauth_query = select uname,phash from user_lookup($1)logfile = /var/log/pgbouncer.logpidfile = /home/postgres/pgbouncer.pidadmin_users = adminuser = postgresmax_db_connections = 220log_connections = 0log_disconnections = 0Do you think this can depend on the server_idle_timeout default config value?Thanks a lot,Nicola