Re: [PATCH] Add max_logical_replication_slots GUC

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

In response to

Responses

Browse pgsql-hackers by date

  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