On Fri, Jun 18, 2021 at 08:47:21PM -0700, Peter Geoghegan wrote:
> On Mon, Jun 14, 2021 at 1:11 PM Bruce Momjian <[email protected]> wrote:
> > FYI, the most recent PG 14 relnote doc build is at:
> >
> > https://momjian.us/pgsql_docs/release-14.html
>
> I just pushed a commit that makes the existing vacuum_index_cleanup
> reloption and INDEX_CLEANUP VACUUM parameter support disabling the
> "Allow vacuum to skip index vacuuming when the number of removable
> index entries is insignificant" behavior. This should be mentioned in
> the release notes.
Agreed. I updated the PG 14 release notes to be current as of today,
and adjusted your item --- patch attached.
--
Bruce Momjian <[email protected]> https://momjian.us
EDB https://enterprisedb.com
If only the physical world exists, free will is an illusion.
diff --git a/doc/src/sgml/release-14.sgml b/doc/src/sgml/release-14.sgml
index 28d0e1396b..33b7bf7d57 100644
--- a/doc/src/sgml/release-14.sgml
+++ b/doc/src/sgml/release-14.sgml
@@ -6,7 +6,7 @@
<formalpara>
<title>Release date:</title>
- <para>2021-??-?? (AS OF 2021-05-15)</para>
+ <para>2021-??-?? (AS OF 2021-06-20)</para>
</formalpara>
<sect2>
@@ -424,12 +424,14 @@ Author: Tom Lane <[email protected]>
<!--
Author: Tom Lane <[email protected]>
2021-04-07 [3db826bd5] Tighten up allowed names for custom GUC parameters.
+Author: Tom Lane <[email protected]>
+2021-04-07 [3db826bd5] Tighten up allowed names for custom GUC parameters.
-->
<para>
Require <link linkend="runtime-config-custom">custom server
- variable</link> names to match the pattern used for unquoted
- <acronym>SQL</acronym> identifiers (Tom Lane)
+ variable</link> names to use only character which are valid for
+ unquoted <acronym>SQL</acronym> identifiers (Tom Lane)
</para>
</listitem>
@@ -691,12 +693,20 @@ Author: Peter Eisentraut <[email protected]>
<!--
Author: Peter Geoghegan <[email protected]>
2021-04-07 [5100010ee] Teach VACUUM to bypass unnecessary index vacuuming.
+Author: Peter Geoghegan <[email protected]>
+2021-06-18 [3499df0de] Support disabling index bypassing by VACUUM.
-->
<para>
Allow vacuum to skip index vacuuming when the number of removable
index entries is insignificant (Masahiko Sawada, Peter Geoghegan)
</para>
+
+ <para>
+ The vacuum parameter <link
+ linkend="sql-vacuum"><literal>INDEX_CLEANUP</literal></link> has a
+ new default of <literal>auto</literal> to enable this optimization.
+ </para>
</listitem>
<listitem>
