Re: DROP INVALID INDEXES command

From: Roman Khapov <rkhapov(at)yandex-team(dot)ru>
To: Álvaro Herrera <alvherre(at)kurilemu(dot)de>
Cc: Kirill Reshke <reshkekirill(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Andrey Borodin <x4mmm(at)yandex-team(dot)ru>
Subject: Re: DROP INVALID INDEXES command
Date: 2026-07-03 11:04:41
Message-ID: B2A7A5D6-D611-4914-90C8-3CF1A508CD44@yandex-team.ru
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


>
> I still think that adding ad-hoc DDL syntax is the wrong amount of
> intrusion.
>

Hi!

Did v3 with new function - pg_drop_invalid_indexes, for now without
support of skip locked logic, due we currently have no agreement
about it..

--
Best regards,
Roman Khapov

Attachment Content-Type Size
v3-0001-introduce-pg_drop_invalid_indexes.patch application/octet-stream 8.5 KB
unknown_filename text/plain 2 bytes

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2026-07-03 11:05:33 Re: Proposal: Conflict log history table for Logical Replication
Previous Message Greg Burd 2026-07-03 10:54:37 Re: Tepid: selective index updates for heap relations