我需要配置我的pgbouncer用于超过2000个客户端连接的工作,我正在阅读有关如何使用max连接的一些信息,然后我已经理解了我必须在pgbouncer上执行max_client_con = 2000,但是default_pool_size,它们是什么,不仅仅是要问一些支持,以便了解在大型客户端连接上配置pgbouncer的正确方法
postgres.conf
port = 5432 # (change requires restart) max_connections = 100 # (change requires restart) unix_socket_directory = '/var/run/postgresql' # (change requires restart)
pgbouncer.ini
[pgbouncer] logfile = /var/log/postgresql/pgbouncer.log pidfile = /var/run/postgresql/pgbouncer.pid listen_addr = 127.0.0.1 listen_port = 6432 unix_socket_dir = /var/run/postgresql auth_type = md5 auth_file = /etc/pgbouncer/userlist.txt admin_users = carlos pool_mode = statement server_reset_query = DISCARD ALL max_client_conn = 100 default_pool_size = 20
