v.25.5Improvement
Allow ALTER TABLE
AllowALTER TABLE ... MOVE|REPLACE PARTITIONfor tables on differentplain_rewritabledisks. #79566 (Julia Kartseva).
Why it matters
This feature allows users to move or replace partitions between tables located on different disks configured asplain_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 differentplain_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.