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 1jZ3nw-0001lQ-AM for pgsql-hackers@arkaria.postgresql.org; Thu, 14 May 2020 02:41:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jZ3nt-0003p0-LF for pgsql-hackers@arkaria.postgresql.org; Thu, 14 May 2020 02:40:57 +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 1jZ3nt-0003os-EH for pgsql-hackers@lists.postgresql.org; Thu, 14 May 2020 02:40:57 +0000 Received: from momjian.us ([72.94.173.45]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jZ3nq-0002gb-HB for pgsql-hackers@postgresql.org; Thu, 14 May 2020 02:40:56 +0000 Received: from bruce by momjian.us with local (Exim 4.92) (envelope-from ) id 1jZ3no-0006ix-Ma; Wed, 13 May 2020 22:40:52 -0400 Date: Wed, 13 May 2020 22:40:52 -0400 From: Bruce Momjian To: Kyotaro Horiguchi Cc: noah@leadboat.com, pgsql-hackers@postgresql.org Subject: Re: PG 13 release notes, first draft Message-ID: <20200514024052.GA8853@momjian.us> References: <20200512203809.GA4666@momjian.us> <20200513.115633.157251733478541458.horikyota.ntt@gmail.com> <20200513151518.GA20111@momjian.us> <20200514.095141.1411370156366955955.horikyota.ntt@gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20200514.095141.1411370156366955955.horikyota.ntt@gmail.com> User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Thu, May 14, 2020 at 09:51:41AM +0900, Kyotaro Horiguchi wrote: > At Wed, 13 May 2020 11:15:18 -0400, Bruce Momjian wrote in > > On Wed, May 13, 2020 at 11:56:33AM +0900, Kyotaro Horiguchi wrote: > It is just an more accurate (not an detailed) version of the > previously proposed description. If we simplify that, I choose to > remove explanation on wal_skip_threshold. > > How about this? > > WAL-logging is now skipped while all kinds of bulk-insertion, then > relations are sync'ed to disk at commit. Previously this was done > only for COPY operations, but the implementation had a bug that could > cause data loss during crash recovery. OK, I went with this text, stating WAL "generation" is skipped: Allow skipping of WAL for full table writes if wal_level is 'minimal' (Kyotaro Horiguchi) Relations larger than wal_skip_threshold will have their files fsync'ed rather than generating WAL. Previously this was done only for COPY operations, but the implementation had a bug that could cause data loss during crash recovery. -- Bruce Momjian https://momjian.us EnterpriseDB https://enterprisedb.com + As you are, so once was I. As I am, so you will be. + + Ancient Roman grave inscription +