Date: Tue, 29 Mar 2022 14:01:41 +0200
From: hubert depesz lubaczewski <depesz@depesz.com>
Sender: depesz@depesz.com
To: Amit Kapila <amit.kapila16@gmail.com>
Cc: vignesh C <vignesh21@gmail.com>,
	pgsql-bugs mailing list <pgsql-bugs@postgresql.org>
Subject: Re: Logical replication stops dropping used initial-sync replication
 slots
Message-ID: <20220329120140.GA29363@depesz.com>
Reply-To: depesz@depesz.com
References: <20220317142426.GA727@depesz.com>
 <20220318122758.GA25022@depesz.com>
 <CALDaNm0+k0M6SDSVEsRWoS8VkwYtTz3WAQcjPWRheKu2-ym-pQ@mail.gmail.com>
 <20220321144341.GA27089@depesz.com>
 <CALDaNm1S-DtphU51d3orNknjyNQEjAOL90jXAxkis_n4rtS=eA@mail.gmail.com>
 <20220322034847.GA15952@depesz.com>
 <CALDaNm2Za2KU-R07dXKGYjM1UF1SZtbBR1BycxHC-dzjc0OSnA@mail.gmail.com>
 <20220322112646.GA14817@depesz.com>
 <20220325083856.GA26455@depesz.com>
 <CAA4eK1KbBAPfLL86x0nTz8f3dKKgETv9Udx3Ex8yKBArx+u1FA@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
In-Reply-To: 
 <CAA4eK1KbBAPfLL86x0nTz8f3dKKgETv9Udx3Ex8yKBArx+u1FA@mail.gmail.com>
User-Agent: Mutt/1.10.1 (2018-07-13)
Archived-At: 
 <https://www.postgresql.org/message-id/20220329120140.GA29363%40depesz.com>
Precedence: bulk

On Tue, Mar 29, 2022 at 04:57:42PM +0530, Amit Kapila wrote:
> What was your setting for max_logical_replication_workers? It should

4 on source, and 50 on replica. That could be related. Should I increase this on source?

> be more than max_sync_workers_per_subscription as that is taken from
> the pool of max_logical_replication_workers. One possible reason for

The thing is that, in next tests, it seemed to *usually* work. And break
just sometimes.

> It is good if you are able to proceed but we might get some clue about
> the problem you are seeing if you can show subscriber-side logs.

Will keep that in mind. The boxes I was testing it are gone, but if the
problem will resurface, I'll make the logs available.

Best regards,

depesz