ALTER TABLE ... DETACH PARTITION CONCURRENTLY

What this does

Non-blocking: SHARE UPDATE EXCLUSIVE allows ordinary reads and writes to continue on both the parent and the partition during the detach.

Read more

• /blog/postgres-lock-mode-cheat-sheet
• /blog/ddl-lock-cheat-sheet

More in Partitions

• ALTER TABLE ... ATTACH PARTITION HIGH
• ALTER TABLE ... ATTACH PARTITION on PostgreSQL 11 and earlier HIGH
• ALTER TABLE ... DETACH PARTITION HIGH