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