3 ms·
I'm curious how innodb solves this, given that the theory of indices pretty much demands write amplification by definition. Postgres' WA is worse?
by asah 7y ago
I'm curious how innodb solves this, given that the theory of indices pretty much demands write amplification by definition. Postgres' WA is worse?
- edoceo 7y agoIts from an Uber post - more story and follow up in this post https://dba.stackexchange.com/questions/226879/did-postgresql-write-amplification-reduction-warm-efforts-get-released-in-10-1 https://dba.stackexchange.com/questions/226879/did-postgresq...
- djd20 7y agoYeah - they indexed every single column.... also - what may not have worked for uber, will be just fine for 99% of usecases. How often do you work with that kind of load. What they moved to isn't so much mysql, rather mysql used as a key value store with 0 relational database usage. Not really a postgres issue, rather one of being too big for relational databases.