Adding a new column should be simple, but poor planning can grind deployments to a halt. A new column changes the schema, impacts read and write performance, and can break downstream services if done carelessly. The key is treating schema evolution as part of the release process, not a side note.
First, define the new column in terms of data type, nullability, default values, and indexing. Avoid adding high-cost indexes during peak traffic—schedule changes to reduce lock contention. For databases like PostgreSQL, ADD COLUMN with a default value can rewrite the entire table, so consider adding the column as nullable, backfilling in batches, and setting constraints later.
Second, deploy in phases. Update the schema, backfill, update the application code, and remove deprecated logic. This sequence prevents breaking queries and reduces rollback risk. Use feature flags to control how and when the new column is read and written.