3 ms·
So the major issue detailed here is that postgres basically uses immutables rows which creates performance issues with writes. Just read about their new schema
by Illniyar 10y ago
So the major issue detailed here is that postgres basically uses immutables rows which creates performance issues with writes.
Just read about their new schemaless db in their blog an the first paragraph contains this:
"The basic entity of data is called a cell. It is immutable, and once written, it cannot be overwritten. (In special cases, we can delete old records.) A cell is referenced by a row key, column name, and ref key. A cell’s contents are updated by writing a new version with a higher ref key but same row key and column name."
So, mmm..., not saying that postgres didn't pose a problem for them but I think postgres' db model fits better to their new db then mysql. They probably had to work really hard to get mysql to work like postgres.
Without this issue, it looks like two things needed.to be done with postgres that would have solved their problems have indexes that point to primary id and do logical replication (which they say a plugin solved in 9.4).
Is this a case of "I got burned by something so I won't use it again"
- Illniyar 10y agoSo more from here: https://eng.uber.com/schemaless-part-two/ https://eng.uber.com/schemaless-part-two/ "Each Schemaless shard is a separate MySQL database, and each MySQL database server contains a set of MySQL databases. Each database contains a MySQL table for the cells (called the entity table) and a MySQL table for each secondary index, along with a set of auxiliary tables." So... 1 table, with 1 index and manually created and updated secondary index tables. With this scheme I can only assume postgres will work just as well or better.