Every story and comment from the Hacker News API, in a layout borrowed from 2001.
A comment on Rails migrations with no downtime. Parent comment
ALTER TABLE performance will eventually improve. PostgreSQL 9.1 lifts-off the lock-up limitation.
But what a performant ALTER TABLE will not improve is its intrusiveness to applications. When you change the schema you break the app.
That's the problem.
http://chronicdb.com/blogs/change_is_not_the_enemy
There are no comments on this comment yet.
ALTER TABLE performance will eventually improve. PostgreSQL 9.1 lifts-off the lock-up limitation.
But what a performant ALTER TABLE will not improve is its intrusiveness to applications. When you change the schema you break the app.
That's the problem.
http://chronicdb.com/blogs/change_is_not_the_enemy