Introduce the ability to enable/disable indexes using ALTER INDEX

Edit
ID 5274
Title Introduce the ability to enable/disable indexes using ALTER INDEX
CI (CFBot) Needs rebase! Needs rebase since 2 months. Failing since 2 months.
Additional links previous successfully applied patch (outdated):
Summary
Stats (from CFBot) Unknown
Topic SQL Commands
Tags
Created 2024-09-27 11:43:23
Last modified 2025-09-08 12:13:32 (4 days ago)
Latest email 2025-07-24 01:43:12 (1 month ago)
Status
PG19-1 (2025-07-01 – 2025-07-31): Withdrawn
2025-03 (2025-03-01 – 2025-04-08): Moved to different CF
2025-01 (2025-01-01 – 2025-01-31): Moved to different CF
2024-11 (2024-11-01 – 2024-11-30): Moved to different CF
Target version 18
Authors Shayon Mukherjee (shayonj)
Reviewers Sami Imseih (simseih), newtglobal postgresql_contributors (newtpostgrescontributors)Become reviewer
Committer
Links Git
Emails
Proposal to Enable/Disable Index using ALTER INDEX
First at 2024-09-09 21:38:35 by Shayon Mukherjee <shayonj at gmail.com>
Latest at 2025-07-24 01:43:12 by Michael Paquier <michael at paquier.xyz>
Latest attachment (v18-0001-Introduce-the-ability-to-set-index-visibility-us.patch) at 2025-04-28 11:23:15 from Shayon Mukherjee <shayonj at gmail.com>
    Attachment (v18-0001-Introduce-the-ability-to-set-index-visibility-us.patch) at 2025-04-28 11:23:15 from Shayon Mukherjee <shayonj at gmail.com> (Patch: Yes)
    Attachment (v17-0001-Introduce-the-ability-to-set-index-visibility-us.patch) at 2025-04-07 21:39:46 from Sami Imseih <samimseih at gmail.com> (Patch: Yes)
    Attachment (v16-0001-Introduce-the-ability-to-set-index-visibility-us.patch) at 2025-04-07 20:47:56 from Shayon Mukherjee <shayonj at gmail.com> (Patch: No)
    Attachment (v15-0001-Introduce-the-ability-to-set-index-visibility-us.patch) at 2025-04-05 21:00:59 from Shayon Mukherjee <shayonj at gmail.com> (Patch: No)
    Attachment (v14-0001-Introduce-the-ability-to-set-index-visibility-us.patch) at 2025-04-01 22:50:28 from Shayon Mukherjee <shayonj at gmail.com> (Patch: No)
    Attachment (sami-v13-edits.txt) at 2025-04-01 18:41:17 from Sami Imseih <samimseih at gmail.com> (Patch: Yes)
    Attachment (v13-0001-Introduce-the-ability-to-enable-disable-indexes-.patch) at 2025-03-07 07:21:34 from Shayon Mukherjee <shayonj at gmail.com> (Patch: No)
    Attachment (v12-0001-Introduce-the-ability-to-set-index-visibility-us.patch) at 2025-02-23 15:41:11 from Shayon Mukherjee <shayonj at gmail.com> (Patch: No)
    Attachment (v11-0001-minor-indentation-changes.no-cfbot) at 2025-02-08 05:40:52 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v11-0001-Introduce-the-ability-to-set-index-visibility-us.patch) at 2025-02-04 09:44:43 from Shayon Mukherjee <shayonj at gmail.com> (Patch: No)
    Attachment (v10-0001-minor-indentation-fix.no-cfbot) at 2025-02-03 02:45:43 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v10-0001-Introduce-the-ability-to-set-index-visibility-us.patch) at 2025-02-01 07:35:25 from Shayon Mukherjee <shayonj at gmail.com> (Patch: No)
    Attachment (0002-Add-the-invisible-tag-for-indexes-in-d.patch) at 2025-01-24 15:26:23 from Benoit Lobréau <benoit.lobreau at gmail.com> (Patch: Yes)
    Attachment (v9-0001-Introduce-the-ability-to-set-index-visibility-usi.patch) at 2025-01-12 19:58:14 from Shayon Mukherjee <shayonj at gmail.com> (Patch: No)
    Attachment (v8-0001-Introduce-the-ability-to-enable-disable-indexes-u.patch) at 2025-01-11 21:10:18 from Shayon Mukherjee <shayonj at gmail.com> (Patch: No)
    Attachment (v7-0001-Introduce-the-ability-to-enable-disable-indexes-u.patch) at 2024-12-31 16:52:16 from Shayon Mukherjee <shayonj at gmail.com> (Patch: No)
    Attachment (v6-0001-Introduce-the-ability-to-enable-disable-indexes-u.patch) at 2024-12-30 17:33:02 from Shayon Mukherjee <shayonj at gmail.com> (Patch: No)
    Attachment (v5-0001-Introduce-the-ability-to-enable-disable-indexes-u.patch) at 2024-12-28 16:09:42 from Shayon Mukherjee <shayonj at gmail.com> (Patch: No)
    Attachment (v4-0001-Introduce-the-ability-to-enable-disable-indexes-u.patch) at 2024-12-06 16:24:41 from Shayon Mukherjee <shayonj at gmail.com> (Patch: No)
    Attachment (v3-0001-Introduce-the-ability-to-enable-disable-indexes-u.patch) at 2024-10-17 13:59:34 from Shayon Mukherjee <shayonj at gmail.com> (Patch: No)
    Attachment (v1-0001-Ability-to-enable-disable-indexes-through-GUC.patch) at 2024-09-26 17:39:23 from Shayon Mukherjee <shayonj at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Proof-of-Concept-Ability-to-enable-disable-indexe.patch) at 2024-09-24 13:19:45 from Shayon Mukherjee <shayonj at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Introduce-the-ability-to-enable-disable-indexes.patch) at 2024-09-22 18:20:53 from Shayon Mukherjee <shayonj at gmail.com> (Patch: Yes)
    Attachment (0001-Introduce-the-ability-to-enable-disable-indexes.patch) at 2024-09-22 17:42:48 from Shayon Mukherjee <shayonj at gmail.com> (Patch: Yes)
History
When Who What
2025-09-08 12:13:32 Shayon Mukherjee (shayonj) Closed in commitfest PG19-1 with status: Withdrawn
2025-07-11 21:15:24 CFbot Patch needs rebase
2025-04-09 11:11:11 Shayon Mukherjee (shayonj) Closed in commitfest 2025-03 with status: Moved to next CF
2025-04-07 21:40:54 Sami Imseih (simseih) New status: Ready for Committer
2025-03-31 03:01:27 Sean Massey (syd-sean) Removed syd-sean from reviewers
2025-03-31 03:01:19 Sean Massey (syd-sean) Added syd-sean as reviewer
2025-03-16 15:02:39 Shayon Mukherjee (shayonj) Changed targetversion to 18
2025-03-07 07:32:43 CFbot Patch does not need rebase anymore
2025-03-07 06:38:54 newtglobal postgresql_contributors (newtpostgrescontributors) Added newtpostgrescontributors as reviewer
2025-02-28 15:48:38 CFbot Patch needs rebase
2025-02-23 16:01:43 CFbot Patch does not need rebase anymore
2025-02-17 09:23:29 CFbot Patch needs rebase
2025-02-04 09:51:39 Shayon Mukherjee (shayonj) Closed in commitfest 2025-01 with status: Moved to next CF
2024-12-31 17:04:42 Sami Imseih (simseih) Added simseih as reviewer
2024-12-11 05:00:37 Michael Paquier (michael-kun) Closed in commitfest 2024-11 with status: Moved to next CF
2024-10-16 16:21:26 Shayon Mukherjee (shayonj) Changed gitlink to https://github.com/shayonj/postgres/pull/1
2024-10-16 16:21:26 Shayon Mukherjee (shayonj) Changed name to Introduce the ability to enable/disable indexes using ALTER INDEX
2024-09-27 13:51:37 Shayon Mukherjee (shayonj) Changed authors to Shayon Mukherjee (shayonj)
2024-09-27 11:43:23 Shayon Mukherjee (shayonj) Attached mail thread CANqtF-oXKe0M=0QOih6H+sZRjE2BWAbkW_1+9nMEAMLxUJg5jA@mail.gmail.com
2024-09-27 11:43:23 Shayon Mukherjee (shayonj) Created patch record
Edit