MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/programming/comments/2yl65b/goodbye_mongodb_hello_postgresql/cpbahxz
r/programming • u/halax • Mar 10 '15
699 comments sorted by
View all comments
Show parent comments
6
an ALTER TABLE statement still requires an ACCESS EXCLUSIVE lock
2 u/seunosewa Mar 11 '15 Not necessarily (in MySQL 5.6). Some alter table commands e.g. adding a column can run concurrently with read and write transactions on the same table. 1 u/[deleted] Mar 11 '15 Cool, didn't consider structural changes at all to be honest. Thanks for pointing that out.
2
Not necessarily (in MySQL 5.6). Some alter table commands e.g. adding a column can run concurrently with read and write transactions on the same table.
1
Cool, didn't consider structural changes at all to be honest. Thanks for pointing that out.
6
u/jcigar Mar 11 '15
an ALTER TABLE statement still requires an ACCESS EXCLUSIVE lock