Introduce the ability to enable/disable indexes using ALTER INDEX

Edit

Git

5274

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v14, Patch count: 1, First patch: +1563−26, All patches: +1563−26

Topic

SQL Commands

Created

2024-09-27 11:43:23

Last modified

2025-03-16 15:02:39 (2 weeks ago)

Latest email

2025-04-05 21:00:59 (3 hours ago)

Status

2025-03: Needs review

2025-01: Moved to next CF

2024-11: Moved to next CF

Target version

Authors

Shayon Mukherjee (shayonj)

Reviewers

Sami Imseih (simseih), newtglobal postgresql_contributors (newtpostgrescontributors)Become reviewer

Committer

Links

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-04-05 21:00:59 by Shayon Mukherjee <shayonj at gmail.com>
Latest 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>
    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-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