Hubert (depesz) Lubaczewski • 1/4/2026

Waiting for PostgreSQL 19 – Implement ALTER TABLE … MERGE/SPLIT PARTITIONS … command

The article details the upcoming PostgreSQL 19 feature implementing ALTER TABLE ... MERGE PARTITIONS and ALTER TABLE ... SPLIT PARTITION commands. It explains the initial, naive implementation that uses an ACCESS EXCLUSIVE LOCK, making it unsuitable for large, high-load tables but useful as a foundation for future, more parallel and less restrictive versions.

0 comments

#postgresql #Alter Table #Database Partitioning