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 1lGWiB-0000YQ-PH for pgsql-hackers@arkaria.postgresql.org; Mon, 01 Mar 2021 00:46:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lGWiA-00059S-IH for pgsql-hackers@arkaria.postgresql.org; Mon, 01 Mar 2021 00:46:58 +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 1lGWiA-000580-5Z for pgsql-hackers@lists.postgresql.org; Mon, 01 Mar 2021 00:46:58 +0000 Received: from mail-il1-x12f.google.com ([2607:f8b0:4864:20::12f]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lGWi4-0007y6-Je for pgsql-hackers@postgresql.org; Mon, 01 Mar 2021 00:46:57 +0000 Received: by mail-il1-x12f.google.com with SMTP id e7so13184967ile.7 for ; Sun, 28 Feb 2021 16:46:51 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=IE99RkEQyFZfFiyWY2XFTm7MMp1qu5AEWfIDMLhBwLg=; b=GaLT7FjCutWagLM60GQ8yYy8LZCcAly6iiIwP4FiFjXbUqID5juJyWJUeCAKdpq+Rg FQ/nMjZDbNEohx7v2ZTGdBo3EbD0haq7ihkDs5wLIFsyf5ri2V5IpqsUDt1V1v9/6tFN r5pRsWYLy9Z4QquRBRzO7LZaQ+PLx7V09b+TeZWCZs5PJQz+d0xyGIt60wNMWSdQvsli ksrr7gTd+y/9cgrCgnniKkck1wAFsOzHLrtyAqJl9pj141sKO0hh9luZOXEMRLDpQaCE rQI5Ud1kLWdiE4ndkbDWkWKHMRYuVfS4gAu2WP4fUZyfbFbqjiZfPmKGAfdpxOHlNjBx b3FA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to:user-agent; bh=IE99RkEQyFZfFiyWY2XFTm7MMp1qu5AEWfIDMLhBwLg=; b=SS1JVnKRm2pLQZg5xZ1EcqVansjSXfjtFYuWF8H/uBKwXwzz2cF2BpJGI7Ex4lV0Ud YoSaKyiP1tCvrlxaB3SzBBYXjCk+rhNw+6lMr1QSOmqn1dKP1oxPqDE1UWEH6xu8ha3A TNXuKD8T7YK8syt2gUxU2srbbiSeoDEgM7Aop7N3pt1arNp3+9BtHu5ZlChdH96WdaGX TCksjZH34fpUfpbpon6Jo/eWjekKimrv2hifP8GiLzxNEkJ6pplqYccdg+9IEMNMsB14 dKKHFmDUvMEMGdyFzBMIuf20Krf6FqU7KWRbWZwOxvAXJfU7uvZegtN1qBQj2Ljb6OXZ Skbw== X-Gm-Message-State: AOAM532rOwrtfTAVZZIIZEas1rcRaiC6mq5MeyzuPaKYB72wVZgR7Hpj QlECxl+NIImgN9/Kr5aTdhZwLg== X-Google-Smtp-Source: ABdhPJzmNLDGiEoekLmqtwoLgLKrrKXRa/kbsHGanQGaH4Gl86GygVJ3SrnPmcp1XKN3bUpbFeHMyQ== X-Received: by 2002:a05:6e02:1d02:: with SMTP id i2mr11464027ila.30.1614559609933; Sun, 28 Feb 2021 16:46:49 -0800 (PST) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id w9sm2450656iox.20.2021.02.28.16.46.48 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Sun, 28 Feb 2021 16:46:49 -0800 (PST) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id 0DF4C801070; Sun, 28 Feb 2021 18:46:47 -0600 (CST) Date: Sun, 28 Feb 2021 18:46:47 -0600 From: Justin Pryzby To: Michael Paquier Cc: pgsql-hackers@postgresql.org, Bruce Momjian , Thomas Munro Subject: Re: doc review for v14 Message-ID: <20210301004647.GF20769@telsasoft.com> References: <20201222041153.GK30237@telsasoft.com> <20201227202604.GC26311@telsasoft.com> <20210210235557.GQ20012@telsasoft.com> <20210222080345.GA23313@telsasoft.com> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="enGqbSaueFq5omEL" Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --enGqbSaueFq5omEL Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Wed, Feb 24, 2021 at 04:18:51PM +0900, Michael Paquier wrote: > This leaves 0003, 0004, 0005, 0010, 0012, 0018, 0020 and 0021 as these > did not look like improvements after review. It looks like you applied 0010...but I agree that it's not an improvement. It appears that's something I intended to go back and revisit myself. The rest of the patch looks right, to me. Subject: [PATCH 10/21] doc review for checksum docs doc/src/sgml/wal.sgml | 18 +++++++++--------- I'm suggesting to either revert that part, or apply these more polished changes in 0002. -- Justin --enGqbSaueFq5omEL Content-Type: text/x-diff; charset=us-ascii Content-Disposition: attachment; filename="0001-Partially-revert-bcf2667bf62d72faced64cb60ffbd2e599a.patch" From 03d014809720d90ba43c780cb34fc82dd7173c8d Mon Sep 17 00:00:00 2001 From: Justin Pryzby Date: Fri, 26 Feb 2021 19:42:54 -0600 Subject: [PATCH 1/2] Partially revert bcf2667bf62d72faced64cb60ffbd2e599a0ebe8 --- doc/src/sgml/wal.sgml | 18 +++++++++--------- 1 file changed, 9 insertions(+), 9 deletions(-) diff --git a/doc/src/sgml/wal.sgml b/doc/src/sgml/wal.sgml index 02f576a1a9..66de1ee2f8 100644 --- a/doc/src/sgml/wal.sgml +++ b/doc/src/sgml/wal.sgml @@ -237,19 +237,19 @@ - By default, data pages are not protected by checksums, but this can optionally be - enabled for a cluster. When enabled, each data page will be ASSIGNED a - checksum that is updated when the page is written and verified each time - the page is read. Only data pages are protected by checksums; internal data + Data pages are not checksum protected by default, but this can optionally be + enabled for a cluster. When enabled, each data page will be assigned a + checksum that is updated when the page is written and verified every time + the page is read. Only data pages are protected by checksums, internal data structures and temporary files are not. - Checksums verification is normally ENABLED when the cluster is initialized using initdb. They can also be enabled or disabled at a later time as an offline operation. Data checksums are enabled or disabled at the full cluster - level, and cannot be specified for individual databases or tables. + level, and cannot be specified individually for databases or tables. @@ -260,9 +260,9 @@ - When attempting to recover from corrupt data, it may be necessary to bypass - the checksum protection. To do this, temporarily set the configuration - parameter . + When attempting to recover from corrupt data it may be necessary to bypass + the checksum protection in order to recover data. To do this, temporarily + set the configuration parameter . -- 2.17.0 --enGqbSaueFq5omEL Content-Type: text/x-diff; charset=us-ascii Content-Disposition: attachment; filename="0002-Second-attempt-to-improve-checksum-docs.patch" From bed0d532bc2415cea1e2da54b6842053ecc27e04 Mon Sep 17 00:00:00 2001 From: Justin Pryzby Date: Fri, 26 Feb 2021 19:56:25 -0600 Subject: [PATCH 2/2] Second attempt to improve checksum docs 'assigned' is odd Each not every Colon not comma Rephase 'Checksums are normally enabled...', since this is easy to mis-interpret and sounds like they're enabled by default Do not repeat: 'to recover...data' --- doc/src/sgml/wal.sgml | 14 +++++++------- 1 file changed, 7 insertions(+), 7 deletions(-) diff --git a/doc/src/sgml/wal.sgml b/doc/src/sgml/wal.sgml index 66de1ee2f8..347be030b2 100644 --- a/doc/src/sgml/wal.sgml +++ b/doc/src/sgml/wal.sgml @@ -238,18 +238,18 @@ Data pages are not checksum protected by default, but this can optionally be - enabled for a cluster. When enabled, each data page will be assigned a - checksum that is updated when the page is written and verified every time - the page is read. Only data pages are protected by checksums, internal data + enabled for a cluster. When enabled, a checksum is included in each data page + when the page is written and verified each time + the page is read. Only data pages are protected by checksums; internal data structures and temporary files are not. - Checksums are normally enabled when the cluster is initialized using initdb. They can also be enabled or disabled at a later time as an offline operation. Data checksums are enabled or disabled at the full cluster - level, and cannot be specified individually for databases or tables. + level, and cannot be specified for individual databases or tables. @@ -260,8 +260,8 @@ - When attempting to recover from corrupt data it may be necessary to bypass - the checksum protection in order to recover data. To do this, temporarily + When attempting to recover from corrupt data, it may be necessary to bypass + the checksum protection. To do this, temporarily set the configuration parameter . -- 2.17.0 --enGqbSaueFq5omEL--