max_pool,num_init_children :
通过pgpool连接进数据库的个数不能超过 num_init_children * max_pool 个
connection_life_time:
缓存的连接的过期时长。(超过num_init_children * max_pool后在一定空闲时间内需要释放的连接)
reset_query_list :
退出一个session时发送给后台的命令。 # 'ABORT; DISCARD ALL'
如果指定了discard all 则在会话中如果有使用create temp table语句创建的表,则会在会话退出时自动drop清理掉。
[pg93@localhost ~]$ pgbench -M extended -n -r -f ./test.sql -c 16 -j 4 -C -T 30 -h 127.0.0.1 -p 5001 transaction type: Custom query scaling factor: 1 query mode: extended number of clients: 16 number of threads: 4 duration: 30 s number of transactions actually processed: 2396 tps = 79.753552 (including connections establishing) tps = 39971.639488 (excluding connections establishing) statement latencies in milliseconds: 149.590196 select 1; [pg93@localhost ~]$ pgbench -M extended -n -r -f ./test.sql -c 16 -j 4 -C -T 30 -h 127.0.0.1 -p 9999 transaction type: Custom query scaling factor: 1 query mode: extended number of clients: 16 number of threads: 4 duration: 30 s number of transactions actually processed: 3357 tps = 111.552647 (including connections establishing) tps = 2498.656516 (excluding connections establishing) statement latencies in milliseconds: 106.540466 select 1;