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