pgpool连接池

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;

 

转载于:https://www.cnblogs.com/xxvv/p/3766273.html