Re: Correct docs re: rewriting indexes when table rewrite is skipped
Robert Haas <robertmhaas@gmail.com>
From: Robert Haas <robertmhaas@gmail.com>
To: James Coleman <jtc331@gmail.com>
Cc: Matthias van de Meent <boekewurm+postgres@gmail.com>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2022-03-30T21:41:36Z
Lists: pgsql-hackers
On Wed, Mar 30, 2022 at 4:33 PM James Coleman <jtc331@gmail.com> wrote: > Hmm, having it match the way it works makes sense. Would you feel > comfortable with an intermediate step (queueing up that as a larger > change) changing the clause to something like "indexes will still have > to be rebuilt unless the system can guarantee that the sort order is > proven to be unchanged" (with appropriate wordsmithing to be a bit > less verbose if possible)? Yeah, that seems fine. It's arguable how much detail we should go into here - but a statement of the form you propose is not misleading, and that's what seems most important to me. -- Robert Haas EDB: http://www.enterprisedb.com
Commits
-
docs: Changing column type doesn't always require an index rebuild.
- fa25bebb827a 15.0 landed