Skip to end of banner
Go to start of banner

PGpool investigation and experiments

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 7 Current »

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 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