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 1mUmDs-0007n8-Bv for pgsql-docs@arkaria.postgresql.org; Mon, 27 Sep 2021 08:42:53 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mUmDq-0004Kv-Tv for pgsql-docs@arkaria.postgresql.org; Mon, 27 Sep 2021 08:42:50 +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 1mUmDq-0004Km-KX for pgsql-docs@lists.postgresql.org; Mon, 27 Sep 2021 08:42:50 +0000 Received: from mail.postgrespro.ru ([93.174.131.139]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mUmDn-0000tB-EF for pgsql-docs@lists.postgresql.org; Mon, 27 Sep 2021 08:42:50 +0000 Received: from [192.168.28.242] (cyclops.postgrespro.ru [93.174.131.138]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client did not present a certificate) by mail.postgrespro.ru (Postfix) with ESMTPSA id E05C921C899D for ; Mon, 27 Sep 2021 11:42:45 +0300 (MSK) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=postgrespro.ru; s=mail; t=1632732165; bh=xXF16Fp0lqXyr3BcXp7PFwJScHBu01P53sdIdR1RLGs=; h=From:Subject:To:Date; b=GW4yPh5l9M73N55wyfolDgp0H7jRieWnt05+hPEn/KRi9Xq/RnY+VDEGaEtZEUMd6 21a3q37AQJAMdvg6iVx4f/yGngC1uTHUfF4rDFe0AE1kotaQ0vPVZPsLc58oBfKD2K qhVYMVmAw2dMKiyWlPJYXhgkiX5L3PJWQo+qgAmU= From: Ekaterina Kiryanova Subject: Minor doc fixes To: pgsql-docs@lists.postgresql.org Message-ID: <8a14e78f-6991-7a6e-4711-fe376635f2ad@postgrespro.ru> Date: Mon, 27 Sep 2021 11:42:40 +0300 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Thunderbird/78.13.0 MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="------------9A417A15529E30308A9E42E8" Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------9A417A15529E30308A9E42E8 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit Hi! I've come across some minor inconsistencies in PostgreSQL 14 docs. Please review the attached patch. -- Ekaterina Kiryanova Technical Writer Postgres Professional file:///home/ladyune/patches/minor_doc_fixes.patch --------------9A417A15529E30308A9E42E8 Content-Type: text/x-patch; charset=UTF-8; name="minor_doc_fixes.patch" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="minor_doc_fixes.patch" diff --git a/doc/src/sgml/btree.sgml b/doc/src/sgml/btree.sgml index f569f93f352..a9200ee52e6 100644 --- a/doc/src/sgml/btree.sgml +++ b/doc/src/sgml/btree.sgml @@ -664,7 +664,7 @@ options(relopts local_relopts *) returns certain implementation-level heuristics will fail to identify and delete even one garbage index tuple (in which case a page split or deduplication pass resolves the issue of an incoming new tuple not - fitting on a leaf page). The worst case number of versions that + fitting on a leaf page). The worst-case number of versions that any index scan must traverse (for any single logical row) is an important contributor to overall system responsiveness and throughput. A bottom-up index deletion pass targets suspected @@ -706,7 +706,7 @@ options(relopts local_relopts *) returns This is expected with any B-Tree index that is subject to significant version churn from UPDATEs that rarely or never logically modify the columns that the index covers. - The average and worst case number of versions per logical row can + The average and worst-case number of versions per logical row can be kept low purely through targeted incremental deletion passes. It's quite possible that the on-disk size of certain indexes will never increase by even one single page/block despite @@ -811,7 +811,7 @@ options(relopts local_relopts *) returns constraints) to use deduplication. This allows leaf pages to temporarily absorb extra version churn duplicates. Deduplication in unique indexes augments bottom-up index deletion, - especially in cases where a long-running transactions holds a + especially in cases where a long-running transaction holds a snapshot that blocks garbage collection. The goal is to buy time for the bottom-up index deletion strategy to become effective again. Delaying page splits until a single long-running diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml index 2f0def9b19a..0e590059e89 100644 --- a/doc/src/sgml/catalogs.sgml +++ b/doc/src/sgml/catalogs.sgml @@ -13116,7 +13116,7 @@ SELECT * FROM pg_locks pl LEFT JOIN pg_prepared_xacts ppx pg_stats_ext_exprs is also designed to present the information in a more readable format than the underlying catalogs — at the cost that its schema must be extended whenever the structure - of statistics in pg_statistic changes. + of statistics in pg_statistic_ext changes. diff --git a/doc/src/sgml/ref/alter_subscription.sgml b/doc/src/sgml/ref/alter_subscription.sgml index bec5e9c483f..db9713e6667 100644 --- a/doc/src/sgml/ref/alter_subscription.sgml +++ b/doc/src/sgml/ref/alter_subscription.sgml @@ -65,8 +65,8 @@ ALTER SUBSCRIPTION name RENAME TO < Commands ALTER SUBSCRIPTION ... REFRESH PUBLICATION and - ALTER SUBSCRIPTION ... {SET|ADD|DROP} PUBLICATION ... with refresh - option as true cannot be executed inside a transaction block. + ALTER SUBSCRIPTION ... {SET|ADD|DROP} PUBLICATION ... with refresh + option as true cannot be executed inside a transaction block. These commands also cannot be executed when the subscription has two_phase commit enabled, diff --git a/doc/src/sgml/ref/commit.sgml b/doc/src/sgml/ref/commit.sgml index 5f244cdd3c1..43f9e984bcc 100644 --- a/doc/src/sgml/ref/commit.sgml +++ b/doc/src/sgml/ref/commit.sgml @@ -97,7 +97,7 @@ COMMIT; The command COMMIT conforms to the SQL standard. The - form COMMIT TRANSACTION is a PostgreSQL extension. + form COMMIT TRANSACTION is a PostgreSQL extension. diff --git a/doc/src/sgml/ref/initdb.sgml b/doc/src/sgml/ref/initdb.sgml index 3d888387126..9d47cacbe0b 100644 --- a/doc/src/sgml/ref/initdb.sgml +++ b/doc/src/sgml/ref/initdb.sgml @@ -283,7 +283,7 @@ PostgreSQL documentation By default, initdb will write instructions for how to start the cluster at the end of its output. This option causes those instructions to be left out. This is primarily intended for use - by tools that wrap initdb in platform specific + by tools that wrap initdb in platform-specific behavior, where those instructions are likely to be incorrect. diff --git a/doc/src/sgml/ref/psql-ref.sgml b/doc/src/sgml/ref/psql-ref.sgml index fcab5c0d51a..5ef401916f2 100644 --- a/doc/src/sgml/ref/psql-ref.sgml +++ b/doc/src/sgml/ref/psql-ref.sgml @@ -1936,9 +1936,9 @@ testdb=> The status of each kind of extended statistics is shown in a column named after its statistic kind (e.g. Ndistinct). - "defined" means that it was requested when creating the statistics, + defined means that it was requested when creating the statistics, and NULL means it wasn't requested. - You can use pg_stats_ext if you'd like to know whether + You can use pg_stats_ext if you'd like to know whether ANALYZE was run and statistics are available to the planner. diff --git a/doc/src/sgml/spgist.sgml b/doc/src/sgml/spgist.sgml index 18f1f3cdbd8..b8b6d6b8e7d 100644 --- a/doc/src/sgml/spgist.sgml +++ b/doc/src/sgml/spgist.sgml @@ -875,7 +875,7 @@ typedef struct spgLeafConsistentOut Note: the compress method is only applied to - values to be stored. The consistent methods receive query scankeys + values to be stored. The consistent methods receive query scankeys unchanged, without transformation using compress. diff --git a/doc/src/sgml/test-decoding.sgml b/doc/src/sgml/test-decoding.sgml index fe7c9783fac..cf736bd41af 100644 --- a/doc/src/sgml/test-decoding.sgml +++ b/doc/src/sgml/test-decoding.sgml @@ -40,8 +40,8 @@ postgres=# SELECT * FROM pg_logical_slot_get_changes('test_slot', NULL, NULL, 'i - We can also get the changes of the in-progress transaction and the typical - output, might be: + We can also get the changes of the in-progress transaction, and the typical + output might be: postgres[33712]=#* SELECT * FROM pg_logical_slot_get_changes('test_slot', NULL, NULL, 'stream-changes', '1'); --------------9A417A15529E30308A9E42E8--