v.25.5Improvement

Allow ALTER TABLE

Allow ALTER TABLE ... MOVE|REPLACE PARTITION for tables on different plain_rewritable disks. #79566 (Julia Kartseva).
Enable the use of ALTER TABLE ... MOVE PARTITION and ALTER TABLE ... REPLACE PARTITION commands for tables that store data on different plain_rewritable disks.

Why it matters

This feature allows users to move or replace partitions between tables located on different disks configured as plain_rewritable. It addresses the limitation where these operations were previously restricted to the same disk, providing more flexibility in managing partition data across multiple storage devices.

How to use it

Users can perform partition operations across tables on different plain_rewritable disks by executing ALTER TABLE ... MOVE PARTITION or ALTER TABLE ... REPLACE PARTITION commands as usual. The feature works transparently if the involved tables are on disks marked as plain_rewritable in the storage configuration.