Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uc1Ix-0082ch-3H for pgpool-general@arkaria.postgresql.org; Wed, 16 Jul 2025 12:32:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uc1Iu-009zQo-1K for pgpool-general@arkaria.postgresql.org; Wed, 16 Jul 2025 12:32:08 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uc1It-009zQh-S6 for pgpool-general@lists.postgresql.org; Wed, 16 Jul 2025 12:32:08 +0000 Received: from cloud.gatewaynet.com ([185.90.37.94]) by magus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uc1Is-0083rL-0Q for pgpool-general@lists.postgresql.org; Wed, 16 Jul 2025 12:32:08 +0000 Content-Type: multipart/alternative; boundary="------------odWptSPGJlANpLSReLSCU8LZ" Message-ID: <972d5b98-e59f-4655-b61b-3077226cc12b@cloud.gatewaynet.com> Date: Wed, 16 Jul 2025 13:32:03 +0100 MIME-Version: 1.0 Subject: Re: Poor load balancing performance in PGPool 4.6 on PG13, any config suggestions? To: pgpool-general@lists.postgresql.org References: Content-Language: en-US From: Achilleas Mantzios In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------odWptSPGJlANpLSReLSCU8LZ Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit 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] > --------------odWptSPGJlANpLSReLSCU8LZ Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit

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]
 

--------------odWptSPGJlANpLSReLSCU8LZ--