Re:Just use Postgres
by adityapatadia on Saturday August 17, 2024 @11:45AM
(#41275345)
May be we are the odd one here but we need that data at millisecond latency (no those are not logs, we use ClickHouse for that)
Just wanted to put here that it's possible to scale Mongo to this level.
Personally, I've not seen any application that seriously needs a billion rows in a single table. (except at truly massive scale, but then you're not using Mongo)
The real solution is implementing archiving to a file store like S3 and/or ship it off to a data warehouse. You don't need billions of rows in a `record_history`/`user_audit` table going back 5 years in your production database. Nobody queries the data.