From: Bruce Momjian <bruce@momjian.us>
To: Peter Geoghegan <pg@bowt.ie>
Cc: Simon Riggs <simon.riggs@enterprisedb.com>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: PG 14 release notes, first draft
Date: Thu, 24 Jun 2021 21:56:42 -0400
Message-ID: <20210625015642.GD16214@momjian.us> (raw)
In-Reply-To: <CAH2-Wzk7gZ3SqLWXQ+bhNixLOU=04NuqnruD4DJ1xy4OUCpNwg@mail.gmail.com>
References: <20210510060308.GC6088@momjian.us>
<CANbhV-EMM4nf7Ys-Yae_kY25dXT_3eiOXke2+yw44jgy+4jNsA@mail.gmail.com>
<CAH2-Wzk7gZ3SqLWXQ+bhNixLOU=04NuqnruD4DJ1xy4OUCpNwg@mail.gmail.com>
On Wed, Jun 23, 2021 at 07:45:53AM -0700, Peter Geoghegan wrote:
> On Wed, Jun 23, 2021 at 5:50 AM Simon Riggs
> <simon.riggs@enterprisedb.com> wrote:
> > I just noticed that these commits are missing, yet are very important
> > new features:
> > d9d076222f5b94a8
> > f9900df5f9
> > c98763bf51bf
> >
> > These are important enough to be major features of PG14.
>
> I certainly think that they're important enough to be mentioned.
OK, here is a doc patch to add a mention of this. I originally thought
this was an optimization that wouldn't be of general interest.
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com
If only the physical world exists, free will is an illusion.
Attachments:vacuum.diff (text/x-diff, 1.1K) downloaddiff --git a/doc/src/sgml/release-14.sgml b/doc/src/sgml/release-14.sgmlindex 33b7bf7d57..b6c6a9826f 100644--- a/doc/src/sgml/release-14.sgml+++ b/doc/src/sgml/release-14.sgml@@ -740,6 +740,28 @@ Author: Peter Geoghegan <pg@bowt.ie>
<listitem>
<!--
+Author: Alvaro Herrera <alvherre@alvh.no-ip.org>+2020-11-25 [c98763bf5] Avoid spurious waits in concurrent indexing+Author: Alvaro Herrera <alvherre@alvh.no-ip.org>+2021-01-15 [f9900df5f] Avoid spurious wait in concurrent reindex+Author: Alvaro Herrera <alvherre@alvh.no-ip.org>+2021-02-23 [d9d076222] VACUUM: ignore indexing operations with CONCURRENTLY+-->++ <para>+ Allow vacuum to be more aggressive in removing expired rows during+ certain index operations (Álvaro Herrera)+ </para>++ <para>+ Specifically, <command>CREATE INDEX CONCURRENTLY</command> and+ <command>REINDEX CONCURRENTLY</command> no longer limit row+ expiration of other relations.+ </para>+ </listitem>++ <listitem>+<!--
Author: Fujii Masao <fujii@postgresql.org>
2020-12-08 [e2ac3fed3] Speed up rechecking if relation needs to be vacuumed or
-->
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: bruce@momjian.us, pg@bowt.ie, simon.riggs@enterprisedb.com
Subject: Re: PG 14 release notes, first draft
In-Reply-To: <20210625015642.GD16214@momjian.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox