Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tHNI5-006jD2-UT for pgsql-general@arkaria.postgresql.org; Sat, 30 Nov 2024 13:13:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tHNI1-00GjMM-S5 for pgsql-general@arkaria.postgresql.org; Sat, 30 Nov 2024 13:13:39 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tHNI1-00GjMB-GR for pgsql-general@lists.postgresql.org; Sat, 30 Nov 2024 13:13:38 +0000 Received: from mail-ej1-x631.google.com ([2a00:1450:4864:20::631]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1tHNHz-000KSC-WC for pgsql-general@lists.postgresql.org; Sat, 30 Nov 2024 13:13:37 +0000 Received: by mail-ej1-x631.google.com with SMTP id a640c23a62f3a-aa55171d73cso675116166b.0 for ; Sat, 30 Nov 2024 05:13:35 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1732972414; x=1733577214; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=g/knToIln2qo2rkbkofxR1QB1bJHPIP0ubvYubkWvno=; b=jM0Bfv7wptf1t1PLXa2Qm29OnQD8KoT3l4bCCRrhK46dqPKa9AXTc0aLVcYQ0d4yyQ OHpY4Q5jrtyMgKTOsGNBsegSTZhclzTv1XnHB9dNEdUU7G1rmlnNrCjUN2KiLpjuUvjS j3zkEcDwZ36spLRBlLBN+f88KOKpGMApGwCKFLPN7X1uvKNNJbqRdyySXhA2RJfvv9v7 JXMDt3X1Hzjwen6sF4FZWssVYUswjIik09K0PxGQdFBrQt70HkGuaS9heQIE61P2Bt/j wAq4u23C56EOWkFWejgDskUuB5poeneD5yVZkdmswFDxsPpG5faF3ga+Gfk970DefmD3 aM8w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1732972414; x=1733577214; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=g/knToIln2qo2rkbkofxR1QB1bJHPIP0ubvYubkWvno=; b=uM3DVScrJnaV5LOYlw7xJGhDH3GurpY646kV/lsDAER9JX57HbbnIMFLh6ZGjj9XuC kseESzFe0WA9CzKiMaUXQcAmkJkWz9UnI8wTL+CGsm4B+tNQW6mrOtX55hxAmMTz8gdm znUekUMAgJdWz61v5KxrMEJ7wG3jgfPCys07ZovsfVmi9gyuC8DRLNBnZ6ttxJd2El2u rdx5mBRFWS9d9lEG9/VySvXnV2q1ZWdj+v+62UdrjzaDnzT7Efejy/gAJTDyA3Z5MpCc iiooJV58ZAMvTaUQYqa8sOARHj2xMxLhUU8OzktFdcA73C/G/OtaYDE+5bMis4SZ3uj0 aYVQ== X-Forwarded-Encrypted: i=1; AJvYcCV3ueiuf1yvOnE351T036jGQjWzl7aNzKZBIK/Xuek6Ush/g6SHMpARi9iBXT/NJ6iF0/WoO0s0D2qfSVxe@lists.postgresql.org X-Gm-Message-State: AOJu0YwsbopBr+FVaLDVE2qAlT9wYgsdgcKSJcxKF3y3JD5gxdbxnbE8 qVNVj2tWZKCm2aM58C8O3KjP9iwJceV6FzlN12iPDJjVkFC1h9LH/sWdC9N7cFe0bKGBcJNjt8w Z9soeOO8GL92qjfIE2bECwLaWhuo= X-Gm-Gg: ASbGncu2/aoUxxt5zn+T3SpbdPPUVYSe94UEFEbsUt1oBESPfgkqXORwLJiIP0eH0Dr SJXFakLnanO4IC1k/VOT6WdeW8Nm3k7A= X-Google-Smtp-Source: AGHT+IGNPTPnCyMril62muY8k6D80WEcxhLwC+RmesVL7Xv1wv9SsJO6h5dimg+isWVpRHxh/8Y/c+CYuGtocYFlCYs= X-Received: by 2002:a17:906:3094:b0:a9a:17be:fac7 with SMTP id a640c23a62f3a-aa5945735demr1222658766b.14.1732972413393; Sat, 30 Nov 2024 05:13:33 -0800 (PST) MIME-Version: 1.0 From: Durgamahesh Manne Date: Sat, 30 Nov 2024 18:48:01 +0530 Message-ID: Subject: Regarding logical slots allocation with logical rw To: PostgreSQL mailing lists , pgsql-general Content-Type: multipart/alternative; boundary="0000000000001b24250628211542" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000001b24250628211542 Content-Type: text/plain; charset="UTF-8" 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 --0000000000001b24250628211542 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi=C2=A0

I have 32vcpus and 128GB ram a= nd 13 slots only created but need 18 more logical slots needed=C2=A0 in thi= s case
mwp > 32
max replication slots > 40 alloca= ted=C2=A0
logical rw > 18=C2=A0
wal senders > 55= =C2=A0
mpw > 6
avmw > 3=C2=A0
here 18+6= +3 =3D 27=C2=A0+ 13 used slots=C2=A0 =3D 40=C2=A0
So here howmany= logical slots we can create upto=C2=A0 based on resources=C2=A0
=
Regards,
Durga Mahesh=C2=A0
--0000000000001b24250628211542--