Preserve pg_index.indisclustered across REINDEX CONCURRENTLY
Michael Paquier <michael@paquier.xyz>
Preserve pg_index.indisclustered across REINDEX CONCURRENTLY If the flag value is lost, a CLUSTER query following REINDEX CONCURRENTLY could fail. Non-concurrent REINDEX is already handling this case consistently. Author: Justin Pryzby Discussion: https://postgr.es/m/20200229024202.GH29456@telsasoft.com Backpatch-through: 12
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/catalog/index.c | modified | +7 −1 |
| src/test/regress/expected/create_index.out | modified | +13 −0 |
| src/test/regress/sql/create_index.sql | modified | +9 −0 |
Discussion
- ALTER tbl rewrite loses CLUSTER ON index 32 messages · 2020-02-02 → 2020-04-06