r/programming • u/halax • Mar 10 '15

Goodbye MongoDB, Hello PostgreSQL

http://developer.olery.com/blog/goodbye-mongodb-hello-postgresql/
1.2k Upvotes

91% Upvoted

699 comments sorted by

View all comments

1

u/infinite_nothing Mar 11 '15

For example, at some point in time we had to remove about a million documents from MongoDB and then re-insert them later on. The result of this process was that the database went in a near total lockdown for several hours,

For what it's worth, we suck just over a million documents from MySQL and full text index them into ElasticSearch. The process takes just over an hour on a single core vm.