Search Postgresql Archives

How many max_replication_slots?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux