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 1u4wX2-009oKY-Aa for pgsql-hackers@arkaria.postgresql.org; Wed, 16 Apr 2025 06:46:00 +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 1u4wWz-0080oo-Mv for pgsql-hackers@arkaria.postgresql.org; Wed, 16 Apr 2025 06:45:58 +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 1u4wWz-0080og-Cl for pgsql-hackers@lists.postgresql.org; Wed, 16 Apr 2025 06:45:58 +0000 Received: from mail-ua1-x92a.google.com ([2607:f8b0:4864:20::92a]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u4wWy-000KM6-08 for pgsql-hackers@lists.postgresql.org; Wed, 16 Apr 2025 06:45:57 +0000 Received: by mail-ua1-x92a.google.com with SMTP id a1e0cc1a2514c-86b9b1def28so5211281241.3 for ; Tue, 15 Apr 2025 23:45:56 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1744785955; x=1745390755; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=cLfJyEwwk88m2/XvUIbbyYL1LKXtz7VkOTpyoz7Qhgk=; b=MUtb3bTtcM4P6NtLf3YDVipJcE2gSA6C2cEUYEJtov5qAz1vGQxVwGQNosMnFhd7lx X1SCL+JFSoOFia770w/SmFw8sv13tLAs2gFUTySFtiWAiKnsFo71LF7iik+2V3AJu4NL 2+A1M/vMCfuRTP9929Ia2jQmpr5eAVcc/QwHIL7jLJMEp21N5y4P/4TMo14T90ld+QUg EtF3NhK0zkjMOY3P4T+khI8P4ztcRcWMRZLvsVOpfgTpRNJ4fqqxzhhq1BQZkjTNVTnS UmH5u1T9DTn4DPGem4G6DC+GeFqzwqwxOVTDqNZU09zXBoyi8/dIUp/Itt8PZQnPXhc4 ItdQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1744785955; x=1745390755; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=cLfJyEwwk88m2/XvUIbbyYL1LKXtz7VkOTpyoz7Qhgk=; b=g82cfAyfmuBY7tok30kRdDHra6K+kVrGT3d9N/GC79Q8q0ea5+XEo2QcGRcHMPdCeL N0H3STkthVRA6GoqbHC+L7H/vwGk5TR9fHPQbuhqcGn+zp4PtZB2CUoZEjazOrmByv5Z 8bepHtdRYGe6OXRsnHnUOsqjHJHATlIkyBt7ETzbsvDidbxerMh2DOf/xIRITKlYmem5 cCzRT2NSDC79rceGZ/fpadhSJs+0ufdnovnkArVEpEu05iEPuwrxM1MZcvipCcCaoMn1 sTdHL3VJELwb5m6mSKrm/qSjkslwsfy9p2Ni9VsiJAfGSCFpe+dDRY0JAa6i1h2o3Zn2 daeg== X-Forwarded-Encrypted: i=1; AJvYcCW5SxovqUYaDdI7KPX++CQGeUem4x4nNuo1rGZ8FjRlGdgEViMQLJ/RxqGFz24KOQDpnyssnglcaixwoLUX@lists.postgresql.org X-Gm-Message-State: AOJu0Yzrs09GKzSX246ObojY4jQvw09fh6WASPKBZi/cAtvG0ZZen4xR YOj9Pf38YB6zVbBtHOy6ixKx7qiKGMtCfOZtsrAD89YUCgyiXiX/ivk1qxS5NXjSKv15xwDinIX 7iI6Zx7Lfhdgg5dj+ozNa88Pg98M= X-Gm-Gg: ASbGncvyGUMLl/8WGsq/MxRZkBUKTadTR9XV/Icd64w5mlJpHgdPm1q9qQqkp/Mv1ay 8ZMXX4BibYyVPW+O5aJa7Yvq4LEG2P4IOtkhNUCXUJDfrH/t256JwLlsAJpHmtLLWuAkSzJlgms X9tnL7NQJiApQbRT3VhlP1xsI= X-Google-Smtp-Source: AGHT+IF2QU7YMy5kjDpDnyZUuhvE9i4jLIMBvKIW2gU0Wt17nLw1WSx/ImZwnvf9MjtLqMqle1gLZ4eIdZBGHpdg4Cc= X-Received: by 2002:a05:6102:2243:b0:4bb:e511:15a6 with SMTP id ada2fe7eead31-4cb59207f12mr192436137.11.1744785955563; Tue, 15 Apr 2025 23:45:55 -0700 (PDT) MIME-Version: 1.0 References: <1798838.1744759182@sss.pgh.pa.us> <20FB597F-641F-48F8-8428-D8DDBA802D58@yandex-team.ru> <212D5973-FDD0-4CF5-BCD0-2760EC319DF3@yandex-team.ru> <1D0DD42E-0CFC-4983-ADCD-6FB742F9DAD7@yandex-team.ru> In-Reply-To: <1D0DD42E-0CFC-4983-ADCD-6FB742F9DAD7@yandex-team.ru> From: Ashutosh Bapat Date: Wed, 16 Apr 2025 12:15:44 +0530 X-Gm-Features: ATxdqUH8Vh9vxI7jlmkOpEFJqnu0pCrJcCXTJ9bbaG7samRb1zpeNVJa0WPzRG4 Message-ID: Subject: Re: Built-in Raft replication To: Andrey Borodin Cc: Tom Lane , Konstantin Osipov , Greg Sabino Mullane , Nikolay Samokhvalov , PostgreSQL Hackers Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, Apr 16, 2025 at 11:57=E2=80=AFAM Andrey Borodin wrote: > > > > > On 16 Apr 2025, at 11:18, Ashutosh Bapat = wrote: > > > > Having only some of the nodes act as DCS > > and others purely PostgreSQL nodes will reduce waste of resources. > > But typically you need more DCS nodes than PostgreSQL nodes. Did you mean In a small HA setup this might be true. But not when there are many replicas. But ... > =E2=80=9CHaving only some nodes act as PostgreSQL and others purely DCS n= odes will reduce waste of resources=E2=80=9D? I mean, whatever the setup may be one shouldn't require to deploy a big PostgreSQL server just because DCS needs majority. --=20 Best Wishes, Ashutosh Bapat