From: hubert depesz lubaczewski <depesz@depesz.com>
To: Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: Excessive number of replication slots for 12->14 logical replication
Date: Fri, 15 Jul 2022 09:45:40 +0200
Message-ID: <20220715074540.GA26521@depesz.com> (raw)
In-Reply-To: <20220715.135532.1618828427814537234.horikyota.ntt@gmail.com>
References: <20220714115155.GA5439@depesz.com>
<20220715.135532.1618828427814537234.horikyota.ntt@gmail.com>
On Fri, Jul 15, 2022 at 01:55:32PM +0900, Kyotaro Horiguchi wrote:
> Thus, not just about logical replication, some spare slots are
> necessary to keep things running smoothly. I guess that it is
> widely(?) recommended to provide at least one or two spare slots to
> allow replication reconnection in case of silent disconnections, but I
> haven't found something like that in the documentation.. In your case,
> it seems to me larger number of spare slots makes the server run more
> smoothly, *I* don't think 10 spare slots affect anything badly.
OK. The explanation makes sense, but leads to problem - we have 50
max replication slots, which gives me 20 spare slots.
And I'm not sure how much should I increase it so that it will still
work.
Plus - there is the problem that increasing max_replication_slots
requires restart :(
Anyway, will deal with it, now that I understand the issue. Thanks
a lot.
Best regards,
depesz
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: depesz@depesz.com, horikyota.ntt@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: Excessive number of replication slots for 12->14 logical replication
In-Reply-To: <20220715074540.GA26521@depesz.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox