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