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 1u58Xs-00CoeH-Rq for pgsql-hackers@arkaria.postgresql.org; Wed, 16 Apr 2025 19:35: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 1u58Xr-0040g0-3a for pgsql-hackers@arkaria.postgresql.org; Wed, 16 Apr 2025 19:35: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 1u58Xq-0040fr-Nq for pgsql-hackers@lists.postgresql.org; Wed, 16 Apr 2025 19:35:39 +0000 Received: from mail-lj1-x22a.google.com ([2a00:1450:4864:20::22a]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u58Xp-000QBT-1S for pgsql-hackers@lists.postgresql.org; Wed, 16 Apr 2025 19:35:38 +0000 Received: by mail-lj1-x22a.google.com with SMTP id 38308e7fff4ca-30bfc79ad97so12486541fa.1 for ; Wed, 16 Apr 2025 12:35:37 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1744832136; x=1745436936; darn=lists.postgresql.org; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=wcGWyjwcPFpxLWwhofgXEPIRcHquLr9NhHMHITCqmk8=; b=JXAIlpk+LkQEQcBI3Wx4NR8WwdMSmYQZeHYVuiE/WzOEbMB1wB0XfbKgblxKXyXnwd JxJPPTbl7EFU3Mk8SaFWXg6yvxP4J2++VvvFSPG2NT6eP0dPCPzag+lb6zM0YRUJXX++ TwG4+Yd/W+CMp/tj8zMnTxgKUFkqArtXI5evjoJ+yKPCKUjeEDbvqxcyyHCdlNiLlpZV 1nb7/gGUREtLkFp921/cmXYrS9RFAzA29RpAdWyHDNdlL0NbMQt29WNrggq64yX8/Ntt CXBIXnZ8S0vLaIyIPmRxt07wKgkib0w49+onVkldC01E1eobMsq4ztHS31vpHUnwURH4 HOBw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1744832136; x=1745436936; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=wcGWyjwcPFpxLWwhofgXEPIRcHquLr9NhHMHITCqmk8=; b=cI96NU0Xc6GojDyXDp6+VjbriNM6iBfPER69bxfsHOT1oanSb5rslQo2C9yr4z/ERz ltSTZ7DwhE2n5VBOKxnSEPXIDiJeQmUtiKKmn3+mKxHQr/LhMJ2B5x7JYRukfQaDWxpC VTX8g+bVRo46Ys5MRBxTkrc2rtB8kKGGrsWcSMPgmtSBgoFQxi3Yoni8PaA9iknPWUii BmhkgFPowFkVHFsILuhJTsBpDvNSfW7ZTMcgdPDEQpxjiPNfSTyGOxF+tV+HEqQHHGm5 ar2LeIAkE6YpwZZaavKcH9c+m+lJUcCIcxmd+PLxwOiIP5krx8p7W+ttwdc1WqxvhAlh EXtg== X-Forwarded-Encrypted: i=1; AJvYcCXgqxA8TWusN7/0Dv7HD47DFuq//5qDRw1fnyPVMvi8tMb5RyZZMCOIwkiSDemiPS5ezm9OUwjVfeH7xm/N@lists.postgresql.org X-Gm-Message-State: AOJu0Yzp/sqjwJQzIUDXcq9yQYNh96pe17UKYdP5QfzgbgsTpqrGVysc xO4uYkLOtNnTrK85jYdI71kVKb5tchO2vB7ZfytwBI9ixZCoG44= X-Gm-Gg: ASbGncsEU+/m/DPGXshvmgaf+TBzySLOGcH3T6DEuwweGLJ8hVn6g2HmhnXMZZ2PP6k xDUk+8vhEHt6QQimBAyjadGtkjTb4IDvKxOgg98cfHD/8JwOodIu1hu6bZyiXwXi1RFNtf6S2F4 Jrqen+AMin2t7C3QvFUjH3qCHc48/MYoXkrVwJqMTr2ipxskdOL9V/QyxRgbcWYziRV4boMQYTo ceb5qpkRhX578HBRX+I0cHfqY7fKI0jaueQ9hqJNiu6qz0gacPRtX0j4N0m8bJty/Z53gep0Xk6 TyoygqqFKzfy5AiScDno3dgOKs1zXg== X-Google-Smtp-Source: AGHT+IH0DtYUYSsBeFwfPXQHNEANSlXFabidOTWuapfmjjIdkAH6gqSg5CptPT/KW8pk/V07SZ9utQ== X-Received: by 2002:a2e:a78a:0:b0:30b:f2d7:1e7c with SMTP id 38308e7fff4ca-31086d349c9mr115781fa.5.1744832135987; Wed, 16 Apr 2025 12:35:35 -0700 (PDT) Received: from ark.local ([2a09:bac5:5151:2373::388:a7]) by smtp.gmail.com with ESMTPSA id 38308e7fff4ca-30f4649d668sm25800591fa.1.2025.04.16.12.35.35 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 16 Apr 2025 12:35:35 -0700 (PDT) Received: by ark.local (Postfix, from userid 1000) id C764AF20074; Wed, 16 Apr 2025 22:35:34 +0300 (MSK) Date: Wed, 16 Apr 2025 22:35:34 +0300 From: Konstantin Osipov To: Greg Sabino Mullane Cc: Ashutosh Bapat , Andrey Borodin , Tom Lane , Nikolay Samokhvalov , PostgreSQL Hackers Subject: Re: Built-in Raft replication Message-ID: References: <1798838.1744759182@sss.pgh.pa.us> <20FB597F-641F-48F8-8428-D8DDBA802D58@yandex-team.ru> <212D5973-FDD0-4CF5-BCD0-2760EC319DF3@yandex-team.ru> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk * Greg Sabino Mullane [25/04/16 22:33]: > > Users find it a waste of resources to deploy 3 big PostgreSQL instances > > just for HA where 2 suffice even if they deploy 3 lightweight DCS > > instances. Having only some of the nodes act as DCS and others purely > > PostgreSQL nodes will reduce waste of resources. > > > > A big problem is that putting your DCS into Postgres means your whole > system is now super-sensitive to IO/WAL-streaming issues, and a busy > database doing database stuff is going to start affecting the DCS stuff. Affecting in what way? Do you have a scenario in mind where an external state provider would act differently (better)? > With three lightweight DCS servers, you don't really need to worry about > how stressed the database servers are. In that way, I feel etcd et al. are > adhering to the unix philosophy of "do one thing, and do it well." -- Konstantin Osipov, Moscow, Russia