News for hackers. Stuff that matters.
Re:12 Months with MongoDB by saurik on Monday October 25, 2010 @08:30PM (#1832301)
Database servers like PostgreSQL can do the most common updates (add, delete, rename columns) instantly, S they Re abstracting over the underlying data storage. Only changing the type of a column should require reading and writing it, and you can do that change using a new temporary column and renaming it around, rather than using a whole new table. Even the alterations that take time can often be run with MVCC semantics, so existing users won't block. I don't even think MySQL (which is really bad at this) is as bad as the reality you are describing.
Re:12 Months with MongoDB by sbov on Monday October 25, 2010 @09:41PM (#1832540)
It must be a MySQL thing then. At least when using InnoDB, it doesn't do column adds or deletes instantly. If your table is large enough it can take hours - we have several where this is the case. During this time writes to the table are blocked.
Re:12 Months with MongoDB by saurik on Monday October 25, 2010 @10:42PM (#1832693)
(I was on an iPhone, btw, and accidentally hit the shift key instead of "a" a couple times, causing the "S they Re".)