Hello, is this normal? can anyone help?Thanks a lot for your help in advance.NicolaIl giorno mer 10 ott 2018 alle ore 17:03 Nicola Contu <nicola.contu@gmail.com> 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
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
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных