Re: PG 14 release notes, first draft

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Simon Riggs <simon(dot)riggs(at)enterprisedb(dot)com>
Cc: Peter Geoghegan <pg(at)bowt(dot)ie>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: PG 14 release notes, first draft
Date: 2021-06-30 22:20:14
Message-ID: 20210630222014.GA2777@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Jun 29, 2021 at 07:36:47PM +0100, Simon Riggs wrote:
> 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."

Uh, hopefully this idea is captured below.

> Proposed edits:
>
> * "during certain index operations" -> "while concurrent index
> operations run on other tables"

Uh, the problem here is that it isn't clear if we are talking about
concurrent index operations, "concurrently"-enabled index options, or
"concurrently"-enabled concurrent index operations. I went with
"minimal-locking index operations".

> * spell Alvaro's name correctly

Uh, this is the second time Mutt's default to using iso-8859-1 for
non-ASCII attachments has caused confusion. I found that using 'set
send_charset="us-ascii:utf-8"' in Mutt fixed this, so the attachment
should now be fine.

> * "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.

> 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.

--
Bruce Momjian <bruce(at)momjian(dot)us> https://momjian.us
EDB https://enterprisedb.com

If only the physical world exists, free will is an illusion.

Attachment Content-Type Size
vacuum.diff text/x-diff 1.3 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tatsuo Ishii 2021-06-30 22:28:20 Re: [HACKERS] WIP aPatch: Pgbench Serialization and deadlock errors
Previous Message Álvaro Herrera 2021-06-30 21:57:36 Re: Partitioned index can be not dumped