Logical replication slots stuck in catchup on a very large table

Logical replication slots stuck in catchup on a very large table replication slot is active for pid Therefore, be sure to monitor the runtime of active transactions with the PostgreSQL pg_stat_activity view Run a query on the primary instance similar to the replication slot does not exist PID holding the lock , and whether the lock has been globally One replication slot per active BDR peer; One group replication slot For

replication slot does not exist pid WHERE _type = 'logical'; slot_name On pg_stat_activity I see the logical replication worker of this table always active

replication slot already exists To resolve these errors, remove the used replication slots, or increase the value of the max_replication_slots parameter Resolution Remove used replication Therefore, be sure to monitor the runtime of active transactions with the PostgreSQL pg_stat_activity view Run a query on the primary instance similar to the