| From: | Luca Ferrari <fluca1978(at)gmail(dot)com> |
|---|---|
| To: | Koshino Taiki <koshino(at)sraoss(dot)co(dot)jp> |
| Cc: | "pgpool-general(at)lists(dot)postgresql(dot)org" <pgpool-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: doubt about backend max_connections |
| Date: | 2026-02-13 11:07:42 |
| Message-ID: | CAKoxK+41UeKhX16E3kYa_=4=HNX2+k1krLfo3C481vBJGpLTKg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgpool-general |
On Thu, Feb 12, 2026 at 2:17 AM Koshino Taiki <koshino(at)sraoss(dot)co(dot)jp> wrote:
>
> Hi,
>
> The value num_init_children × max_pool applies per backend,
> so every backend will receive max_pool × num_init_children connections from Pgpool-II.
>
Thanks, it is clear now.
> max_pool × num_init_children × 2 ≤ (max_connections − superuser_reserved_connections)
> Because Pgpool-II opens additional connections to send cancel requests, the second formula is safer when query cancellation may occur.
>
I didn't know this, thank you very much for pointing out.
Luca
| From | Date | Subject | |
|---|---|---|---|
| Next Message | zam bak | 2026-02-15 16:50:39 | RPM packages for "aarch64" platform |
| Previous Message | Koshino Taiki | 2026-02-12 01:17:45 | Re: doubt about backend max_connections |