How many max_replication_slots? - Mailing list pgsql-general

From andrew cooke
Subject How many max_replication_slots?
Date
Msg-id 20220426182615.lhwhuwwciqbqiq2v@acooke.org
Whole thread Raw
List pgsql-general
Hi,

How can I estimate the correct value for max_replication_slots
(logical replication, pg 14)?

As far as I understand, they're needed to keep WAL files on the
publisher when something goes wrong.  But we seem to need way, way
more slots than publishers.  Is it one slot per publisher per table?

We have 14 publishers and seem to need more than 100 slots.  Is this
reasonable, or does it indicate some underlying error?  They all share
the same schema with ~60 tables and the logical replication should
generate the union of the publishers on the subscriber.

Thanks,
Andrew



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Backing up a DB excluding certain tables
Next
From: Tom Lane
Date:
Subject: Re: Backing up a DB excluding certain tables