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.96) (envelope-from ) id 1vl5BZ-006l9t-2O for pgsql-hackers@arkaria.postgresql.org; Wed, 28 Jan 2026 13:02:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vl5BY-001Sl1-2I for pgsql-hackers@arkaria.postgresql.org; Wed, 28 Jan 2026 13:02:17 +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.96) (envelope-from ) id 1vl5BY-001Skt-1B for pgsql-hackers@lists.postgresql.org; Wed, 28 Jan 2026 13:02:16 +0000 Received: from mail-ej1-x630.google.com ([2a00:1450:4864:20::630]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vl5BV-00000000sbS-3fil for pgsql-hackers@lists.postgresql.org; Wed, 28 Jan 2026 13:02:16 +0000 Received: by mail-ej1-x630.google.com with SMTP id a640c23a62f3a-b8849dc12f6so1084781666b.1 for ; Wed, 28 Jan 2026 05:02:13 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1769605332; cv=none; d=google.com; s=arc-20240605; b=GoL6Mmsz2LEuA81iI8+jSJ5wojCrTaCyjUJo0TRyrs2Ia9sb80Fifp4rnFkjGmygQL 88Gu5BS34ItfX3YXmXyADvQ3ZLCIoJMQo3pazlJug1JUl2Jl11BYq/9MV6OjiQIbhJ9N 1jfsFLhEXnQQBOWWS0xN/w3fS+HHXw0/cB14F75TcQXiuhLZbwMAbayukP8G8Ir/6/o5 vHWrT+YpxFPjSUt3+0/iiHIeMz1TCOJ1XmHvohNJxYnZYuXJT3ECBWZ7FIvOLe5VIJSA t1fqmGxkqIiEcJZk9C6q2Ig6PxAmV6csFBkUuTssMbT6V3IeJn/8gfcowSHT7AnqARUf wdNw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=TO47mprzuUn4ISDquUXFGrj8roqxy8x5YNl38YMH8t8=; fh=kIBt64k7aEk7dZoCaMx0vXGNjeifN/cr1A5pTih48i0=; b=FyCDeTkmRX2Lv84WWdoubk5G6MGmm4w7mRaLAqaPqJtPy+8pr5j47/maMTkBnHXwdk Q9ZMwnxa+fdCDAJcMmBUnBruTWIT2nYMW7e2BhN8G43tpf0N3DTnRG+NpzTyRp4nCoak CRqprR4BMJTe2PzPhx4COdvsmlVDW3k4g9cTEfBvCXaRWCQ7sfe3EJQp+OxwaQKvaoA6 SIqTUBRPF4s9U+5lwer4TQyJ+RheTejueyTvmQFzsH94jtWjmZ2ok3qSxRUNRb44p2RH vn1RAz40cMIX1Rzz3cC+Q09itEJ1Q5Ex4BfrVj0SpwZOjj+P8Xf3KXEnSeWWMVIoT3jA baBw==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aiven.io; s=google; t=1769605332; x=1770210132; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=TO47mprzuUn4ISDquUXFGrj8roqxy8x5YNl38YMH8t8=; b=IYvjQwdQyg1mZIXpTpAcJdbvbbkbb3vVUJIlmS4p74A4lIVayWqIlOR613WtMBdGUW kE6cCT8qkeMxWld7d4Amc8lus0xpYOe3liACQGQkM8WPCRGNh/LjlkC+SyQNbticjMYh GAT6QHpsBR8SBLS15qZJHGTRKEjsJBMgMFPV4= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1769605332; x=1770210132; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=TO47mprzuUn4ISDquUXFGrj8roqxy8x5YNl38YMH8t8=; b=b+vYIA4wb8GYkK2jruASPm9rh08iMlOu+3eydaG/Pf1eiXPdPqiNGmTx0zkHRsBj/3 YAPSF0fR8ZGyfR49+9z/xDy7eC9AzURq+WS+CVxAJT14EwJ+iggMV008MBiYP84fr64r GXTwAWqq9QJ80opQuxljFoMDecYJKwHY3D2sf3NexWWYxU8BukKvkNLv2NMqKTTdjijb dLz4gCxkhrXsSj7/hrzR3x8oFvLIvzQ2cSD1YmjMElAfxH3WGxPUMR84/A4DT/eSAhlv oa3B91tbfwUS36OYgIjCMDQ/vr/WvHyLPQKubvqUrFVebScf3wQ27qaQ6AJqpwUrLP/p n4wQ== X-Gm-Message-State: AOJu0YxwnTGUYiFVxRhdFYGAC7xvUDG959KRZrQLVMFvaR7qKRSW9OB0 Dt7jVTDvF8LLvrZRuoCntrGlMXObdvRBLA9E3zJHDcVgFgRXxjZgzaXzDnnjDAkpjPV2Rot4XiS 2pHM07qYndb93N3L1RqTE//PWM8RJc1BXfNRvCuhg5eNxx4+rNDsB X-Gm-Gg: AZuq6aKoiiSIWyxwkI/+K6+O1weXleSfOjbOUNSgskpTN3BaHK5eZ63muaM6/oJ2Nag 3917+qjus9r4nbCBd0hyDTaBuR4Uqip/5Zm0uE5dXELaBkjJoluG7AysWlGL9CpZL+M1hcUtFUp STqbVQbjgqiOPit5tFE/0F193xHn4nAZXsQU7gErZGVu/NbuQLOo0UitDSSaXThqyzsx6OXoOTQ Yi96BMBvIQvagCVzKj1rYES/eZtXXbi+nRxyQuidKwzLyhiIIMQJqsnsV6sTk6DfttDicNh2rYC n+k5Fygd8eLQ1ojrr/LVMx1JmupT X-Received: by 2002:a17:907:7b8d:b0:b73:6c97:af4b with SMTP id a640c23a62f3a-b8dab3491b6mr346678866b.45.1769605332295; Wed, 28 Jan 2026 05:02:12 -0800 (PST) MIME-Version: 1.0 References: <202601281248.qjv5oru7hxlz@alvherre.pgsql> In-Reply-To: <202601281248.qjv5oru7hxlz@alvherre.pgsql> From: Ahmed Et-tanany Date: Wed, 28 Jan 2026 14:02:01 +0100 X-Gm-Features: AZwV_Qi_u1gGSZttYV_9T2Y-pTMx2JY0blzUlZUPL5DEbYb0OyAsWGLvc0zbifU Message-ID: Subject: Re: [PATCH] Add max_logical_replication_slots GUC To: =?UTF-8?Q?=C3=81lvaro_Herrera?= Cc: pgsql-hackers@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000398ea0064972593b" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000398ea0064972593b Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Yes, that's what I meant. On Wed, Jan 28, 2026 at 1:55=E2=80=AFPM =C3=81lvaro Herrera wrote: > On 2026-Jan-28, Ahmed Et-tanany wrote: > > > 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, > > Ah, you mean that users doing CREATE SUBSCRIPTION could cause the limit > to be reached, possibly blocking streaming replication. Yeah, it makes > sense to have a separate limit. > > -- > =C3=81lvaro Herrera PostgreSQL Developer =E2=80=94 > https://www.EnterpriseDB.com/ > "[PostgreSQL] is a great group; in my opinion it is THE best open source > development communities in existence anywhere." (Lamar Owe= n) > --=20 Ahmed Et-tanany Aiven: https://aiven.io/ --000000000000398ea0064972593b Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Yes, that's what I meant.

On Wed,= Jan 28, 2026 at 1:55=E2=80=AFPM =C3=81lvaro Herrera <alvherre@kurilemu.de> wrote:
On 2026-Jan-28, Ahmed Et-tanany w= rote:

> In practice, a burst of logical replication activity can exhaust all > available replication slots, which in turn prevents physical standbys<= br> > from connecting or restarting.
>
> This is problematic because logical replication slots are often
> user-managed and can grow dynamically,

Ah, you mean that users doing CREATE SUBSCRIPTION could cause the limit
to be reached, possibly blocking streaming replication.=C2=A0 Yeah, it make= s
sense to have a separate limit.

--
=C3=81lvaro Herrera=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0PostgreSQL Developer= =C2=A0 =E2=80=94=C2=A0 https://www.EnterpriseDB.com/
"[PostgreSQL] is a great group; in my opinion it is THE best open sour= ce
development communities in existence anywhere."=C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 (Lamar Owen)


--
Ahmed Et-tanany
Aiven: https://aiven.io/=
--000000000000398ea0064972593b--