/
PGpool investigation and experiments

PGpool investigation and experiments

Nov 05, 2021

Useful links:

Server configuration https://www.pgpool.net/docs/42/en/html/runtime-config-connection.html#GUC-NUM-INIT-CHILDREN

Parameters relations https://pgpool.net/mediawiki/index.php/Relationship_between_max_pool,_num_init_children,_and_max_connections

https://b-peng.blogspot.com/2020/07/connection-pooling-in-pgpool.html

https://scalegrid.io/blog/postgresql-connection-pooling-part-4-pgbouncer-vs-pgpool/





PGPOOL_CHILD_MAX_CONNECTIONS=1 --env PGPOOL_MAX_POOL=1

PGPOOL_CHILD_MAX_CONNECTIONS=20 --env PGPOOL_MAX_POOL=20

PGPOOL_CHILD_MAX_CONNECTIONS=1 --env PGPOOL_MAX_POOL=20

PGPOOL_CHILD_MAX_CONNECTIONS=5 --env PGPOOL_MAX_POOL=5

PGPOOL_CHILD_MAX_CONNECTIONS=20 --env PGPOOL_MAX_POOL=1

--env PGPOOL_MAX_POOL=20 \

 --env PGPOOL_CHILD_MAX_CONNECTIONS=20 \

 --env PGPOOL_NUM_INIT_CHILDREN=10000 \

Check-in

4.489

3.379

4.648

3.484

4.702

6.036

Check-out

9.681

8.485

10.527

9.564

10.421

12.33

Check-in

4.972

4.514

5.299

5.023

5.65

5.256

Check-out

9.691

10.245

10.588

10.784

10.373

11.406







we saw here 40 connections max





test to confirm results from test#2 (this time we have higher response times)

Test with parameters  PGPOOL_CHILD_MAX_CONNECTIONS=1 --env PGPOOL_MAX_POOL=1

http://carrier-io.int.folio.ebsco.com/grafana/d/q69rYQlik/jmeter-performance?orgId=1&from=1635240812542&to=1635246487021&var-percentile=95&var-test_type=fix_load&var-test=multi_tenants_workflow_2tenants&var-env=int&var-grouping=1s&var-low_limit=250&var-high_limit=700&var-db_name=jmeter&var-sampler_type=All

Test with parameters PGPOOL_CHILD_MAX_CONNECTIONS=20 --env PGPOOL_MAX_POOL=20

http://carrier-io.int.folio.ebsco.com/grafana/d/q69rYQlik/jmeter-performance?orgId=1&from=1635246487020&to=1635252161499&var-percentile=95&var-test_type=fix_load&var-test=multi_tenants_workflow_2tenants&var-env=int&var-grouping=1s&var-low_limit=250&var-high_limit=700&var-db_name=jmeter&var-sampler_type=All

test with parameters PGPOOL_CHILD_MAX_CONNECTIONS=1 --env PGPOOL_MAX_POOL=20

http://carrier-io.int.folio.ebsco.com/grafana/d/q69rYQlik/jmeter-performance?orgId=1&from=1635254998737&to=1635260673216&var-percentile=95&var-test_type=fix_load&var-test=multi_tenants_workflow_2tenants&var-env=int&var-grouping=1s&var-low_limit=250&var-high_limit=700&var-db_name=jmeter&var-sampler_type=All

test with parameters PGPOOL_CHILD_MAX_CONNECTIONS=5 --env PGPOOL_MAX_POOL=5

http://carrier-io.int.folio.ebsco.com/grafana/d/q69rYQlik/jmeter-performance?orgId=1&from=1635332660155&to=1635338087949&var-percentile=95&var-test_type=fix_load&var-test=multi_tenants_workflow_2tenants&var-env=int&var-grouping=1s&var-low_limit=250&var-high_limit=700&var-db_name=jmeter&var-sampler_type=All

test with parameters PGPOOL_CHILD_MAX_CONNECTIONS=20 --env PGPOOL_MAX_POOL=1

http://carrier-io.int.folio.ebsco.com/grafana/d/q69rYQlik/jmeter-performance?orgId=1&from=1635338503175&to=1635342792824&var-percentile=95&var-test_type=fix_load&var-test=multi_tenants_workflow_2tenants&var-env=int&var-grouping=1s&var-low_limit=250&var-high_limit=700&var-db_name=jmeter&var-sampler_type=All