3 ms·
does Postgres support online DDL like MySQL? Seeing the docs for this mention "pg-osc supports when a column is being added, dropped or renamed with no data lo
by fierro 5y ago
does Postgres support online DDL like MySQL? Seeing the docs for this mention "pg-osc supports when a column is being added, dropped or renamed with no data loss" but MySQL supports this out-of-the box via the `ALGORITHM=INPLACE, LOCK=NONE` params. Just curious as I'm currently learning about this.
- shayonj 5y agoExcept for few cases, it doesn't. This thread above on MySQL and online DDL is ncie. https://news.ycombinator.com/item?id=30581314 https://news.ycombinator.com/item?id=30581314 pg-osc doc says that since the alter statements can vary in nature, it supports if a rename is being done, so the data is preserved and synced in the order its expected.