Postgres Pro
Downloads
Home   >   mailing lists

Regarding logical slots allocation with logical rw - Mailing list pgsql-general

From Durgamahesh Manne
Subject Regarding logical slots allocation with logical rw
Date
Msg-id CAJCZko+rJFq+Z2k2k1TcYvbxrgxJmzH7cdXo4QJrnQ6ziXTOjw@mail.gmail.com
Whole thread Raw
List pgsql-general
Tree view
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 

pgsql-general by date:

Previous
From: Paul Foerster
Date:
Subject: Re: PostgreSQL 15.10 update corrective action for ATTACH PARTITION/DETACH PARTITION
Next
From: PopeRigby
Date:
Subject: Re: Errors when restoring backup created by pg_dumpall