MIME-Version: 1.0
References: 
 <CAFjdVW8-2kJLr+bRzGXqs3Xg6cgq-hwDg9N5rg8cgnJZ6=WcOA@mail.gmail.com>
 <972d5b98-e59f-4655-b61b-3077226cc12b@cloud.gatewaynet.com>
In-Reply-To: <972d5b98-e59f-4655-b61b-3077226cc12b@cloud.gatewaynet.com>
From: TV <tvfan2014@gmail.com>
Date: Wed, 16 Jul 2025 14:58:35 +0200
Message-ID: 
 <CAFjdVW_em_kd9AOHw5O_+d-NJ=s3Sv0K-nDZ=oeWr+cxh5kxkA@mail.gmail.com>
Subject: Re: Poor load balancing performance in PGPool 4.6 on PG13,
 any config suggestions?
To: pgpool-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000001b29bf063a0b74b4"
Archived-At: 
 <https://www.postgresql.org/message-id/CAFjdVW_em_kd9AOHw5O_%2Bd-NJ%3Ds3Sv0K-nDZ%3DoeWr%2Bcxh5kxkA%40mail.gmail.com>
Precedence: bulk

--0000000000001b29bf063a0b74b4
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

backend_clustering_mode =3D 'streaming_replication'


On Wed, Jul 16, 2025 at 2:32=E2=80=AFPM Achilleas Mantzios <
a.mantzios@cloud.gatewaynet.com> wrote:

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

--0000000000001b29bf063a0b74b4
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">backend_clustering_mode =3D &#39;streaming_replication&#39=
;<br><br></div><br><div class=3D"gmail_quote gmail_quote_container"><div di=
r=3D"ltr" class=3D"gmail_attr">On Wed, Jul 16, 2025 at 2:32=E2=80=AFPM Achi=
lleas Mantzios &lt;<a href=3D"mailto:a.mantzios@cloud.gatewaynet.com">a.man=
tzios@cloud.gatewaynet.com</a>&gt; wrote:<br></div><blockquote class=3D"gma=
il_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,2=
04,204);padding-left:1ex"><u></u>

 =20
   =20
 =20
  <div>
    <p>On 7/16/25 13:13, TV wrote:</p>
    <blockquote type=3D"cite">
     =20
      <div dir=3D"ltr">
        <div>[snip]</div>
        <div><br>
        </div>
        <div>num_init_children =3D 3500</div>
        <div>max_pool =3D 1</div>
        <div>child_life_time =3D 0</div>
        <div>child_max_connections =3D 0</div>
        <div>connection_life_time =3D 500</div>
        <div>client_idle_limit =3D 600</div>
        <div>process_management_mode =3D dynamic</div>
        <div>process_management_strategy =3D gentle</div>
        <div>min_spare_children =3D 50<br>
          max_spare_children =3D 100</div>
        <div>connection_cache =3D on</div>
        <div>load_balance_mode =3D on<br>
          disable_load_balance_on_write =3D &#39;transaction&#39;</div>
        <div>statement_level_load_balance =3D on</div>
        <div><br>
        </div>
      </div>
    </blockquote>
    <p>What&#39;s your <span style=3D"font-family:monospace"><span style=3D=
"color:rgb(0,0,0);background-color:rgb(255,255,255)">backend_</span><span s=
tyle=3D"color:rgb(255,255,255);background-color:rgb(0,0,0)">cluster</span><=
span style=3D"color:rgb(0,0,0);background-color:rgb(255,255,255)">ing_mode =
?</span></span></p>
    <p><span style=3D"font-family:monospace"></span></p>
    <blockquote type=3D"cite">
      <div dir=3D"ltr">
        <div>[snip]<br>
          =C2=A0</div>
        <br>
      </div>
    </blockquote>
  </div>

</blockquote></div>

--0000000000001b29bf063a0b74b4--