Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1njJHZ-0003Be-Nj for pgsql-hackers@arkaria.postgresql.org; Tue, 26 Apr 2022 11:23:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1njJHY-0003Ks-9E for pgsql-hackers@arkaria.postgresql.org; Tue, 26 Apr 2022 11:23:00 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1njJHX-0003Kj-QA for pgsql-hackers@lists.postgresql.org; Tue, 26 Apr 2022 11:22:59 +0000 Received: from forwardcorp1j.mail.yandex.net ([5.45.199.163]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1njJHT-0006Cl-T5 for pgsql-hackers@lists.postgresql.org; Tue, 26 Apr 2022 11:22:58 +0000 Received: from vla5-d6ec41cad181.qloud-c.yandex.net (vla5-d6ec41cad181.qloud-c.yandex.net [IPv6:2a02:6b8:c18:348f:0:640:d6ec:41ca]) by forwardcorp1j.mail.yandex.net (Yandex) with ESMTP id 460E22E1F71; Tue, 26 Apr 2022 14:22:40 +0300 (MSK) Received: from vla1-81430ab5870b.qloud-c.yandex.net (vla1-81430ab5870b.qloud-c.yandex.net [2a02:6b8:c0d:35a1:0:640:8143:ab5]) by vla5-d6ec41cad181.qloud-c.yandex.net (mxbackcorp/Yandex) with ESMTP id 6YPOUGFZZj-MdJSeMKO; Tue, 26 Apr 2022 14:22:40 +0300 X-Yandex-Fwd: 2 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yandex-team.ru; s=default; t=1650972160; bh=oscB9mRp8w17GuTzi/ulv6a1qOxHNZkx1XtyvvCjBTI=; h=Message-Id:References:Date:Cc:In-Reply-To:Subject:To:From; b=kuDiDmcSDL7Nb8JekzkVDZUJTkXG4QLoooP4t52l+mYcI81ww60gUSRJBLNxBkfGa rAFTsojLTK9tj6X9UepcWZF01gshMEz6G97rN7Sr9g3lk65wWIvKyklISDULAWWXSg V4/nOilAfHfIh1dyJZDf4014w/sCD4jiTdszd41Q= Authentication-Results: vla5-d6ec41cad181.qloud-c.yandex.net; dkim=pass header.i=@yandex-team.ru Received: from [IPv6:2a02:6b8:82:600:4d8:dc97:1770:b5fa] (unknown [2a02:6b8:82:600:4d8:dc97:1770:b5fa]) by vla1-81430ab5870b.qloud-c.yandex.net (smtpcorp/Yandex) with ESMTPSA id 5558yOgkFg-MdN4WjDI; Tue, 26 Apr 2022 14:22:39 +0300 (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client certificate not present) Content-Type: text/plain; charset=utf-8 Mime-Version: 1.0 (Mac OS X Mail 13.4 \(3608.120.23.2.7\)) Subject: Re: An attempt to avoid locally-committed-but-not-replicated-to-standby-transactions in synchronous replication From: Andrey Borodin In-Reply-To: <20220425164813.GA2890928@nathanxps13> Date: Tue, 26 Apr 2022 16:22:38 +0500 Cc: Bharath Rupireddy , PostgreSQL Hackers , SATYANARAYANA NARLAPURAM Content-Transfer-Encoding: quoted-printable Message-Id: <0F911A3B-FC1B-4F01-89F3-C2368870DB90@yandex-team.ru> References: <20220425164813.GA2890928@nathanxps13> To: Nathan Bossart X-Mailer: Apple Mail (2.3608.120.23.2.7) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > 25 =D0=B0=D0=BF=D1=80. 2022 =D0=B3., =D0=B2 21:48, Nathan Bossart = =D0=BD=D0=B0=D0=BF=D0=B8=D1=81=D0=B0=D0=BB(=D0=B0= ): >=20 > I'm personally in > favor of just adding a GUC that can be enabled to block canceling > synchronous replication waits +1. I think it's the only option to provide quorum commit guarantees. Best regards, Andrey Borodin.=