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 1kT8jQ-0005NH-3h for pgsql-docs@arkaria.postgresql.org; Thu, 15 Oct 2020 19:16:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kT8jM-0004CF-8d for pgsql-docs@arkaria.postgresql.org; Thu, 15 Oct 2020 19:16:04 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kT8jM-0004AD-2x for pgsql-docs@lists.postgresql.org; Thu, 15 Oct 2020 19:16:04 +0000 Received: from momjian.us ([72.94.173.45]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kT8jJ-0006nG-M4 for pgsql-docs@lists.postgresql.org; Thu, 15 Oct 2020 19:16:03 +0000 Received: from bruce by momjian.us with local (Exim 4.92) (envelope-from ) id 1kT8jI-0005HA-2J; Thu, 15 Oct 2020 15:16:00 -0400 Date: Thu, 15 Oct 2020 15:16:00 -0400 From: Bruce Momjian To: Kasper Kondzielski Cc: pgsql-docs@lists.postgresql.org, jaroslaw.kijanowski@softwaremill.com Subject: Re: Request for further clarification on synchronous_commit Message-ID: <20201015191600.GF3797@momjian.us> References: <159741195522.14321.13812604195366728976@wrigleys.postgresql.org> <20200817174727.GA28474@momjian.us> <20200818145851.GB27231@momjian.us> <20200818171740.GE27231@momjian.us> <20200821201539.GA13363@momjian.us> <20201006233848.GE12277@momjian.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20201006233848.GE12277@momjian.us> User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Tue, Oct 6, 2020 at 07:38:48PM -0400, Bruce Momjian wrote: > On Fri, Aug 21, 2020 at 04:15:39PM -0400, Bruce Momjian wrote: > > How is this for a table? > > > > -- local -- ------------------- standbys ------------------ > > durable query durable commit durable commit > > commit consistency after OS crash after PG crash > > remote_apply X X X X > > on X X X > > remote_write X X > > local X > > off > > I have created the attached doc patch which I plan to apply to all > supported versions of Postgres. I have applied this patch through 9.6. 9.5 didn't have all the options. -- Bruce Momjian https://momjian.us EnterpriseDB https://enterprisedb.com The usefulness of a cup is in its emptiness, Bruce Lee