Regarding logical slots allocation with logical rw

From: Durgamahesh Manne <maheshpostgres9(at)gmail(dot)com>
To: PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org>, pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Regarding logical slots allocation with logical rw
Date: 2024-11-30 13:18:01
Message-ID: CAJCZko+rJFq+Z2k2k1TcYvbxrgxJmzH7cdXo4QJrnQ6ziXTOjw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi

I have 32vcpus and 128GB ram and 13 slots only created but need 18 more
logical slots needed in this case
mwp > 32
max replication slots > 40 allocated
logical rw > 18
wal senders > 55
mpw > 6
avmw > 3
here 18+6+3 = 27 + 13 used slots = 40
So here howmany logical slots we can create upto based on resources

Regards,
Durga Mahesh

Browse pgsql-general by date

  From Date Subject
Next Message PopeRigby 2024-12-01 01:17:31 Re: Errors when restoring backup created by pg_dumpall
Previous Message Paul Foerster 2024-11-30 08:44:25 Re: PostgreSQL 15.10 update corrective action for ATTACH PARTITION/DETACH PARTITION