]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Preserve clustered index after rewrites with ALTER TABLE
authorMichael Paquier <michael@paquier.xyz>
Mon, 6 Apr 2020 02:06:07 +0000 (11:06 +0900)
committerMichael Paquier <michael@paquier.xyz>
Mon, 6 Apr 2020 02:06:07 +0000 (11:06 +0900)
commit3f77a670241d114eb4b65ad6eed52298d28dcef8
treed5ad3e7e3e22bbd1ebaa0cba0446a26811b4d110
parenta850063ee0bc6c2c703117395a51eb3154e907db
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