Re: Dropping index from large, partitioned table

On Tue, Oct 7, 2025 at 5:01 PM Matthew Planchard <msplanchard(at)gmail(dot)com>
wrote:

> I have a very active table with around 1,000 partitions. I would like
> to drop a GIN index on one of its columns.
>
> Unfortunately, this is a top-level index, and so it seems impossible
> to drop the indexes on each partition individually, which means a
> 'drop index' requires holding an access exclusive lock on the entire
> table until the process completes for all children. That process turns
> out to be much too slow, since it requires locking one of our most
>

Too bad there's no ONLY. clause in DROP INDEX.

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!