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 1vnRBF-007CTL-0V for pgsql-hackers@arkaria.postgresql.org; Wed, 04 Feb 2026 00:55:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vnRBD-008Gde-0v for pgsql-hackers@arkaria.postgresql.org; Wed, 04 Feb 2026 00:55:39 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vnRBC-008GdW-3D for pgsql-hackers@lists.postgresql.org; Wed, 04 Feb 2026 00:55:38 +0000 Received: from mail-lf1-x132.google.com ([2a00:1450:4864:20::132]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vnRBA-00000000Rb2-2UfC for pgsql-hackers@lists.postgresql.org; Wed, 04 Feb 2026 00:55:37 +0000 Received: by mail-lf1-x132.google.com with SMTP id 2adb3069b0e04-59dd54b1073so7268131e87.0 for ; Tue, 03 Feb 2026 16:55:36 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1770166534; cv=none; d=google.com; s=arc-20240605; b=i/PaU7K2kAHiyPZ/ouNRjNz6j4a3X2FE2xbHXsp1cs/zietkOodFgb08MCTOJFY1ov vzCBNmcg1I4ArUvKR9VKNq13jga71fte/r1bAB0wu1Z0p/P87jDHyopkPapkMhjPuO/z xbUJGZJxB96IegfsBJY/shxM1V0AjWC5YCPfrm8QrEz1HXFRJ6u/VV9o564W73JoK4cr 4MUYrYUk9udO6Wsln0QMung26bfsaqVcLyewP/aCK7k4EtXDOQ1e/YZp5soN4Ff+j4pS bYlVdKmD10RdaSfm0e6zWFD3zlSgGc4f8m0uUHE8KsUSRgyIV5pnSXHPukVfZ49ZvWUi KXFg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=JHq/2L3V5NnZpGgm98QFks6QFkzuSx2LqAneCNALGJA=; fh=+MdXXSKkNKfrLhttVuEXn0WaRIlJPZJnDZuFAAHTFRY=; b=Y1YWh26mjhL261GaWYmxGnLUVPGpntfYV9o7ONw7z40M9Io6YOrj6LgRZfAU58yj3V CdvIWgSMYydv8Bxaao2f2OMwiKI8ZaOd/3oazeUrTQOr4RMlbUm9g8N2yS1Z9gGTozMC 7mGBwliyhtOclsqhxOY2OkEiUjTILH09jsjeXWVn1m4gVgHWgArJAJwpJ0NLZYZDvEX8 4zEkp1Pp2oAgpzz9+IW8kkU70z4x5qTBucPSTlrWEdM8hQAofml0UCD2Yhml5yGNyLVW qDA8Dvjk60OQJJhSy1pkeOEX5Q3fqsbDumWHWb6xs7hXZ3eWHREQGjNTAdwKyIlsrc6z gd6w==; 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=gmail.com; s=20230601; t=1770166534; x=1770771334; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=JHq/2L3V5NnZpGgm98QFks6QFkzuSx2LqAneCNALGJA=; b=P9Kb4ghyVgLonlHtH5iaz6jsrtD4KNspvSazxPbosXnxhZeo+vJ3Xnl2Q2RIF3jvBu JtvT3I/QVTGYUWhuRUruBobam7LJPsQ1bgQ+UQHDZ4KI2+P15JZ/yNdU+wgteoFSOhGF NYFwXgyNmUn0VU5muqvdQlFgI/toGJjvgLIEmZHGApUaMOuHbkXN3f/uASxiJrmcyj4m 2JCtuMTHrHfB/NC7tbgpzfRfEtyjnY3ryRdA4p6DcuGMwmiayOPsq4afdl6kpJy/No0g IeJXZz+9NLc1QbP3Eyp8+qpy+ipHKX1SnAXOJGBWP4lBB0xSEqjOv9A6y5aoMD2WC1rg ZRjA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1770166534; x=1770771334; h=content-transfer-encoding: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=JHq/2L3V5NnZpGgm98QFks6QFkzuSx2LqAneCNALGJA=; b=kmzK4du0EuDyCz9MiHA91r8hhjAnzRbUDALuO9Yzo0G11NPc+Hswb5eMbDIF3Wti4n ijY+YzA9GA3IfVO1V+cxUN6k8aTKDT/tPxd3EBjSSZxqMnn9H7bImXWsXKPvbl/K/z9V Ng1H/yFxJwx7xxkdC+1NwvizvLlxUSfbxWsb7/e+B3oQrmNG+fDZ8UbZabF52/8eKZwx HFyJQKGk/3h//+Y+grsMmSdOxOI/Lb95nzV7BMS3cl5fycpP/N7FQVIhWcmg5aJjL7Yg MDuk2C7CrqjyQJTkmMgjVLZF8ok76gNlyxRawce5HaA/7Igc7VaehCjuc5gGTHtKtWKO i5FA== X-Forwarded-Encrypted: i=1; AJvYcCVtCIO8qBF7GrSWgMsAe8XGAyPWuZTe+zMHCmeGtvvz5iI0bzvlr2IaF/YQXi7w1WwL5pTxoMd661ENQeAr@lists.postgresql.org X-Gm-Message-State: AOJu0YyfIVAL+Oprhs/OiEPMS1lzjF5l7x0ZA/FTBxKN+wLP627Wr9h2 q/n2GON9rLES0egMxhN39t9bG6fy1+/BWmyXkdR8HRFTrT7RWGJ9uM1RRt/wNh/UmXN6hWeIzOh 9Q/UZXFOqYWEadVuezFYwibBS0ZI7wCj9B8xd X-Gm-Gg: AZuq6aIi7Pgj/G3m9o0zZTlr6XrtdtGo+XaoGWhkt2A1iiCmjk4KHyQAVW0ynWIiHrO NTm7MmWZ5e4yEnvf9+frCGk8VV7qv36IfhfXyyKROKQ8wjU82lV0srL+NhjR4AgI65AunBEFCem dAO9xehiGjD/Vw16eLNoWUw6hSDTgwoz6SzpBYtBDDvqqaS+cYSNkzUUXfkvXvoui1vJv8MIrjB UAkf+ZJx8SYX2sO9vfEijd6mp5LRxzbBQ4RYiRp0giSaLjG/jQCcDPWjW9zW9I9D/P1C4OL14qq nvQFa9HafU3xK1XKZV4Hd/PX0XmIY7oBS4oVD0k= X-Received: by 2002:a05:6512:6c5:b0:59e:1a8:5e86 with SMTP id 2adb3069b0e04-59e38c34dc2mr345839e87.41.1770166533750; Tue, 03 Feb 2026 16:55:33 -0800 (PST) MIME-Version: 1.0 References: <202601281248.qjv5oru7hxlz@alvherre.pgsql> In-Reply-To: From: Masahiko Sawada Date: Wed, 4 Feb 2026 09:54:57 +0900 X-Gm-Features: AZwV_QglhBqNCaqjfBCjYNC9feUhyNJ6d-PplsmjNP_86STRp-QlhiJ-U4O3aEk Message-ID: Subject: Re: [PATCH] Add max_logical_replication_slots GUC To: Ahmed Et-tanany Cc: =?UTF-8?Q?=C3=81lvaro_Herrera?= , pgsql-hackers@lists.postgresql.org Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, Jan 28, 2026 at 10:02=E2=80=AFPM Ahmed Et-tanany wrote: > > Yes, that's what I meant. FYI there is a related discussion on another thread[1]; Now that wal_level=3D'replica' can dynamically become 'logical' WAL level depending on the logical slot presence, there might be users who want to allow physical replication while not for logical replication (decoding) to avoid overheads due to logical WAL logging. Having separate limits for logical slots and physical slots might help such use cases too. Regards, [1] https://www.postgresql.org/message-id/CAEze2WjP0NpAjNioXzLiNkpNQcxCMtaN= ajaQXfufYVcyFyqW1g%40mail.gmail.com --=20 Masahiko Sawada Amazon Web Services: https://aws.amazon.com