PostgreSQL Schema Change Guide
This post is absolutely terrific and has been been my main reference for Reshape, an automated, zero-downtime schema migration tool: <a href="https://github.com/fabianlindfors/reshape" rel="nofollow">https://github.com/fabianlindfors/reshape</a>