Thread: How many max_replication_slots?

How many max_replication_slots?

From
andrew cooke
Date:
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