Hacker News new | ask | show | jobs
by rjh29 911 days ago
Read Uncommitted is fine for aggregate stats, although at that point it would be better to pipe the data into Clickhouse.
1 comments

Yeah there are many use cases where you aren't really using transactions, or where hard accuracy isn't a requirement (you're taking a percentage out of millions of rows) but you need fast write performance. It's very nice and can help you put off transitioning to a "real" data warehouse or a cache for a while.