On Thu, Jul 1, 2021 at 03:13:30PM +0100, Simon Riggs wrote:
> On Wed, Jun 30, 2021 at 11:20 PM Bruce Momjian <br...@momjian.us> wrote:
> > > * "row expiration" is a term not currently used in PG docs, so we
> > > should probably look for something else.
> >
> > Yeah, I changed that to "removing dead rows" which seems to be our
> > standard text.
>
> What you have now looks great for this feature, thanks.
Good.
> > > There are 2 important features here, so the 2nd feature is worth
> > > mentioning also:
> > >
> > > Avoid spurious waits in concurrent indexing
> > >
> > > Previously, multiple concurrent index operations could deadlock or
> > > cause long waits.
> > > Waits are avoided except for indexes with expressions, or WHERE
> > > predicates.
> >
> > OK, I added text to the bottom to try and capture that; new patch
> > attached, now with UTF8 encoding.
>
> The text from "This also avoids..." tries to explain this, but they
> are two separate features, each important in its own right.
>
> So regrettably, this part doesn't capture it, for me.
I see what you mean. This is in the VACUUM section, and this feature,
though from the same commits, has nothing to do with vacuum. Attached
is an updated patch.
--
Bruce Momjian <br...@momjian.us> 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 e96206f899..42cb1d1ed1 100644
--- a/doc/src/sgml/release-14.sgml
+++ b/doc/src/sgml/release-14.sgml
@@ -742,6 +742,28 @@ Author: Peter Geoghegan <p...@bowt.ie>
<listitem>
<!--
+Author: Alvaro Herrera <alvhe...@alvh.no-ip.org>
+2020-11-25 [c98763bf5] Avoid spurious waits in concurrent indexing
+Author: Alvaro Herrera <alvhe...@alvh.no-ip.org>
+2021-01-15 [f9900df5f] Avoid spurious wait in concurrent reindex
+Author: Alvaro Herrera <alvhe...@alvh.no-ip.org>
+2021-02-23 [d9d076222] VACUUM: ignore indexing operations with CONCURRENTLY
+-->
+
+ <para>
+ Allow vacuum to be more aggressive in removing dead rows during
+ minimal-locking index operations (Álvaro Herrera)
+ </para>
+
+ <para>
+ Specifically, <command>CREATE INDEX CONCURRENTLY</command> and
+ <command>REINDEX CONCURRENTLY</command> no longer limit the dead
+ row removal of other relations.
+ </para>
+ </listitem>
+
+ <listitem>
+<!--
Author: Fujii Masao <fu...@postgresql.org>
2020-12-08 [e2ac3fed3] Speed up rechecking if relation needs to be vacuumed or
-->
@@ -2281,6 +2303,23 @@ Author: Michael Paquier <mich...@paquier.xyz>
</para>
</listitem>
+ <listitem>
+<!--
+Author: Alvaro Herrera <alvhe...@alvh.no-ip.org>
+2020-11-25 [c98763bf5] Avoid spurious waits in concurrent indexing
+Author: Alvaro Herrera <alvhe...@alvh.no-ip.org>
+2021-01-15 [f9900df5f] Avoid spurious wait in concurrent reindex
+Author: Alvaro Herrera <alvhe...@alvh.no-ip.org>
+2021-02-23 [d9d076222] VACUUM: ignore indexing operations with CONCURRENTLY
+-->
+
+ <para>
+ Allow index commands using <literal>CONCURRENTLY</command> to
+ avoid waiting for the completion of other operations using
+ <literal>CONCURRENTLY</command> (Álvaro Herrera)
+ </para>
+ </listitem>
+
<listitem>
<!--
Author: Tom Lane <t...@sss.pgh.pa.us>
