Why Uber Engineering Switched from Postgres to MySQL

We’ve represented the old version in red and the new row version in green. Under the hood, Postgres uses another field holding the row version to determine which tuple is most recent. This added field lets the database determine which row tuple to serve to a transaction that may not be allowed to see the latest row version. With Postgres, the primary index and secondary indexes all point directly

[hiroponz]

あとで

[hachiking]

postgresqlの憂鬱

[msykt]

PostgreSQLとMySQLのインターナルの違いが面白い。特にバッファプールの違いの話が面白かった。最初にPostgreSQLにしたのはGIS絡みかな？

[iakio]

"our largest Postgres replicas have 768 GB of memory available, but only about 25 GB of that memory is actually RSS memory faulted in by Postgres processes." お、おぅ

[t-wada]

Uber がシステム規模の拡大に従って PostgreSQL から MySQL 上に構築した独自のスケーラブルなデータストアに移行するに至った背景について

[fjwr38]

なげぇ、後で読もう

[koyancya]

こりゃ大変だな...

[knjname]

ストレージまわりに不満のある人はMySQLに行く印象　高負荷Webアプリの世界だわ…