Preserve clustered index after rewrites with ALTER TABLE
authorMichael Paquier <michael@paquier.xyz>
Mon, 6 Apr 2020 02:03:49 +0000 (11:03 +0900)
committerMichael Paquier <michael@paquier.xyz>
Mon, 6 Apr 2020 02:03:49 +0000 (11:03 +0900)
commita40caf5f862ca8b7e927b2ab2567e934868e9376
tree2c98687392f271307de35ac3e5b868b6397be0e4
parentfc3f4453a2bc95549682e23600b22e658cb2d6d7
Preserve clustered index after rewrites with ALTER TABLE

A table rewritten by ALTER TABLE would lose tracking of an index usable
for CLUSTER.  This setting is tracked by pg_index.indisclustered and is
controlled by ALTER TABLE, so some extra work was needed to restore it
properly.  Note that ALTER TABLE only marks the index that can be used
for clustering, and does not do the actual operation.

Author: Amit Langote, Justin Pryzby
Reviewed-by: Ibrar Ahmed, Michael Paquier
Discussion: https://postgr.es/m/20200202161718.GI13621@telsasoft.com
Backpatch-through: 9.5
src/backend/commands/tablecmds.c
src/backend/utils/cache/lsyscache.c
src/include/utils/lsyscache.h
src/test/regress/expected/alter_table.out
src/test/regress/sql/alter_table.sql