Category

July 20, 2023

ALTER TABLE in Greenplum 7: Avoiding Table Rewrite

Author | Huasong Fu The ALTER TABLE commands are commonly used for operations like adding columns, changing the column data type, and many more. In many cases, such commands require the whole table to be rewritten while holding an exclusive lock on the table. For large tables this can

Read More »