Craig Kerstiens • 9/10/2017

Better database migrations in Postgres

This technical article explains how to perform common PostgreSQL database migrations (adding columns and creating indexes) on large, production-scale databases without causing significant downtime. It details the performance pitfalls of default values and constraints when adding columns, and the locking issues with index creation, offering a multi-step, safer migration approach for each operation.

0 comments

#performance optimization #postgresql #Constraints