Seems all these shops starting out with MongoDB or the like always need to do a huge, complicated migration to a /proper/ optimized data store, when they could have started with a sane design in the first place...
> People needing to query huge amounts of data discovering technology that's been developed over the past 45 years for querying huge amounts of data efficiently; news at 11
Whereas MongoDB is "simple".
First thing to note, I couldn't find any reasoning for the change in the original post. This makes the speculating on it rather pointless, but clearly you are able to fill in the details quite easily somehow.
As a counter point. Last four businesses I've worked at all ran on MongoDB. More happenstance than something I've looked for.
They are all relatively small businesses and all ran fine, the biggest was ingesting 1-10GB/day of new data from their IOT fleet.
So this perspective that everything mongo is fundamentally broken and plain bad is pretty foreign to my real world experience.
These shops all liked what they were doing and there was zero talk of scaling issues or changing out the database.