Re: Poor load balancing performance in PGPool 4.6 on PG13, any config suggestions?

From: TV <tvfan2014(at)gmail(dot)com>
To: pgpool-general(at)lists(dot)postgresql(dot)org
Subject: Re: Poor load balancing performance in PGPool 4.6 on PG13, any config suggestions?
Date: 2025-07-16 12:58:35
Message-ID: CAFjdVW_em_kd9AOHw5O_+d-NJ=s3Sv0K-nDZ=oeWr+cxh5kxkA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgpool-general

backend_clustering_mode = 'streaming_replication'

On Wed, Jul 16, 2025 at 2:32 PM Achilleas Mantzios <
a(dot)mantzios(at)cloud(dot)gatewaynet(dot)com> wrote:

> On 7/16/25 13:13, TV wrote:
>
> [snip]
>
> num_init_children = 3500
> max_pool = 1
> child_life_time = 0
> child_max_connections = 0
> connection_life_time = 500
> client_idle_limit = 600
> process_management_mode = dynamic
> process_management_strategy = gentle
> min_spare_children = 50
> max_spare_children = 100
> connection_cache = on
> load_balance_mode = on
> disable_load_balance_on_write = 'transaction'
> statement_level_load_balance = on
>
> What's your backend_clustering_mode ?
>
> [snip]
>
>
>

In response to

Browse pgpool-general by date

  From Date Subject
Next Message Tatsuo Ishii 2025-07-21 04:12:14 Re: FATAL: simple query "BEGIN" arrived before ending an extended query message
Previous Message Achilleas Mantzios 2025-07-16 12:32:03 Re: Poor load balancing performance in PGPool 4.6 on PG13, any config suggestions?