Re: 2022-06-16 release announcement draft

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jonathan S(dot) Katz" <jkatz(at)postgresql(dot)org>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: 2022-06-16 release announcement draft
Date: 2022-06-13 17:38:01
Message-ID: 3827815.1655141881@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Jonathan S. Katz" <jkatz(at)postgresql(dot)org> writes:
> Please review for technical accuracy and omissions.

A few minor thoughts:

> The PostgreSQL Global Development Group has released PostgreSQL 14.4 to fix an
> issue that could cause silent data corruption when using the
> [`CREATE INDEX CONCURRENTLY`](https://www.postgresql.org/docs/current/sql-createindex.html)
> and [`REINDEX CONCURRENTLY`](https://www.postgresql.org/docs/current/sql-reindex.html)
> commands.

Maybe s/and/or/ ?

> PostgreSQL 14.4 fixes an issue with the
> [`CREATE INDEX CONCURRENTLY`](https://www.postgresql.org/docs/current/sql-createindex.html)
> and [`REINDEX CONCURRENTLY`](https://www.postgresql.org/docs/current/sql-reindex.html)
> that could cause silent data corruption of indexes.

Either leave out "the" or add "commands". That is, "the FOO and BAR
commands" reads fine, "the FOO and BAR" less so. Also, I'm inclined
to be a bit more specific and say that the problem is missing index
entries, so maybe like "... fixes an issue that could cause the [CIC]
and [RIC] commands to omit index entries for some rows".

> Once you upgrade your system to PostgreSQL 14.4, you can fix any silent data
> corruption using `REINDEX CONCURRENTLY`.

Perhaps it is also worth mentioning that you can use REINDEX without
CONCURRENTLY, even before upgrading.

> * Report implicitly-created operator families (`CREATE OPERATOR CLASS`) to event
> triggers.

Maybe "(generated by `CREATE OPERATOR CLASS`)"? As-is, the parenthetical
comment looks more like a mistake than anything else.

The rest looks good.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2022-06-13 18:00:59 Re: replacing role-level NOINHERIT with a grant-level option
Previous Message Tom Lane 2022-06-13 17:25:01 Re: "buffer too small" or "path too long"?