Skip to end of metadata
Go to start of metadata

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=1PGPOOL_CHILD_MAX_CONNECTIONS=20 --env PGPOOL_MAX_POOL=20PGPOOL_CHILD_MAX_CONNECTIONS=1 --env PGPOOL_MAX_POOL=20PGPOOL_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-in4.4893.3794.6483.4844.7026.036
Check-out9.6818.48510.5279.56410.42112.33
Check-in4.9724.5145.2995.0235.655.256
Check-out9.69110.24510.58810.78410.37311.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

  • No labels