3 ms·
No, especially on large tables with billions of records. They make online schema changes impossible. More details: https://github.com/github/gh-ost/issues/331#i
by golondon 4y ago
No, especially on large tables with billions of records. They make online schema changes impossible. More details: https://github.com/github/gh-ost/issues/331#issuecomment-266027731 https://github.com/github/gh-ost/issues/331#issuecomment-266...
- glasshug 4y agoCurious why no one else had mentioned this. Are they using online schema transforms besides gh-ost and Percona? Does Postgres handle this better than MySQL?
- golondon 4y agoPostgres has index concurrently which is better or few other instant things which MySQL 8 also has but you still need to be careful. But some things like adding a column with default value is still hard. https://www.braintreepayments.com/blog/safe-operations-for-high-volume-postgresql/ https://www.braintreepayments.com/blog/safe-operations-for-h... this article has a good guideline on this.