Hacker News Reader

What do you mean "expensive to edit a scalar"? If we're thinking of the same Uber article on mysql -> postgres, IIRC it had to do with write amplification related to updates to indexed columns. I don't think postgres has any problems storing counts, but would be interested to know if I'm wrong.

View on HN

this article https://www.uber.com/blog/postgres-to-mysql-migration/

you're right -- I misunderstood. I thought mysql could do in-place writes to rows, saving mvcc / vacuum work

let me amend my point to: a system designed for storing counters can optimize for that case, while sql DBs will do relatively more IO to incremental a counter

Reply on news.ycombinator.com