| From: | andrew cooke <andrew(at)acooke(dot)org> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | How many max_replication_slots? |
| Date: | 2022-04-26 18:26:15 |
| Message-ID: | 20220426182615.lhwhuwwciqbqiq2v@acooke.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2022-04-26 18:43:13 | Re: Backing up a DB excluding certain tables |
| Previous Message | Adrian Klaver | 2022-04-26 18:18:43 | Re: Backing up a DB excluding certain tables |