Is there a way to speed up simple schema changes like ... ALTER TABLE foo ADD COLUMN bar CHAR(64);
... where foo already contains millions of records? On a live database changes like this can take hours. Even when the database is idle. Is there a better way to do this? S. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend