| From: | Ahmed Et-tanany <ahmed(dot)ettanany(at)aiven(dot)io> |
|---|---|
| To: | Álvaro Herrera <alvherre(at)kurilemu(dot)de> |
| Cc: | pgsql-hackers(at)lists(dot)postgresql(dot)org |
| Subject: | Re: [PATCH] Add max_logical_replication_slots GUC |
| Date: | 2026-01-28 12:42:58 |
| Message-ID: | CAD7nQBD1iy3NAS2YRDUH+zk0g=50px_h_wRsLcFkai7R_RF6VQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Right now, all replication slots share a single global limit:
max_replication_slots.
That means logical and physical replication slots compete for the same pool.
In practice, a burst of logical replication activity can exhaust all
available
replication slots, which in turn prevents physical standbys from connecting
or restarting.
This is problematic because logical replication slots are often user-managed
and can grow dynamically, while physical replication slots are
infrastructure-critical and expected to remain available.
Best regards,
--
Ahmed Et-tanany
Aiven: https://aiven.io/
On Wed, Jan 28, 2026 at 1:28 PM Álvaro Herrera <alvherre(at)kurilemu(dot)de> wrote:
> Hello,
>
> On 2026-Jan-28, Ahmed Et-tanany wrote:
>
> > This provides a separation between logical and total replication
> > slots, and allows users to control logical slot usage independently.
>
> Hmm, why is this useful?
>
> --
> Álvaro Herrera 48°01'N 7°57'E —
> https://www.EnterpriseDB.com/
> "Thou shalt not follow the NULL pointer, for chaos and madness await
> thee at its end." (2nd Commandment for C programmers)
>
--
[image: Aiven] <https://www.aiven.io>
*Ahmed Et-tanany*
Software Engineer, *Aiven*
ahmed(dot)ettanany(at)aiven(dot)io | +491772950423
aiven.io <https://www.aiven.io> | <https://www.facebook.com/aivencloud>
<https://www.linkedin.com/company/aiven/>
<https://twitter.com/aiven_io>
*Aiven Deutschland GmbH*
Alexanderufer 3-7, 10117 Berlin
Geschäftsführer: Oskari Saarenmaa, Kenneth Chen
Amtsgericht Charlottenburg, HRB 209739 B
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Euler Taveira | 2026-01-28 12:44:55 | Re: Pasword expiration warning |
| Previous Message | Matheus Alcantara | 2026-01-28 12:37:14 | Re: [PATCH] llvmjit: always add the simplifycfg pass |