Re: PG 14 release notes, first draft - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: PG 14 release notes, first draft
Date
Msg-id CANbhV-EVj4X7rdH5hZ5V2qHn8Bgc9p-pEvwyoeSFeQ-4HMP+XA@mail.gmail.com
Whole thread Raw
In response to Re: PG 14 release notes, first draft  (Bruce Momjian <bruce@momjian.us>)
Responses Re: PG 14 release notes, first draft
List pgsql-hackers
On Fri, Jun 25, 2021 at 2:56 AM Bruce Momjian <bruce@momjian.us> wrote:
>
> 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.

Perhaps we should also add this text from the commit message to ensure
the importance is understood:
"This is extremely useful in cases where CIC/RC can run for a very long
    time, because that used to be a significant headache for concurrent
    vacuuming of other tables."

Proposed edits:

* "during certain index operations" -> "while concurrent index
operations run on other tables"
* spell Alvaro's name correctly
* "row expiration" is a term not currently used in PG docs, so we
should probably look for something else.


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.

-- 
Simon Riggs                http://www.EnterpriseDB.com/



pgsql-hackers by date:

Previous
From: Jeff Davis
Date:
Subject: Re: Synchronous commit behavior during network outage
Next
From: Tom Lane
Date:
Subject: Re: [PATCH] Make jsonapi usable from libpq