Skip to content

Draft: GPRD - Increase max_client_conn for Readers pgbouncers by 10%

Rafael Henchen requested to merge gprd-cr-7838-increase-max_client_conn-10perc into master

Related to CR - gitlab-com/gl-infra/production#7838 (closed) - GPRD - Increase max_client_conn for read-only pgbouncer on All Patroni Replicas

Capacity planning found a trend that is leading to saturation of pgbouncer_client_conn_replicas in our production Patroni Main cluster a few months - https://gitlab.com/gitlab-com/gl-infra/capacity-planning/-/issues/282#note_1116162710

As discussed on the issue we still have room to increase the max_client_conn for these read-only pgbouncers in all nodes of the Patroni Main cluster.

The plan is to increase max_client_conn by 10% initially and evaluate the impact in the pgbouncer_client_conn_replicas saturation forecast.

Merge request reports