Tejas GP
Notes on databases, backends and the things that break in production.
Folders
Latest
- UPDATE doesn't update In Postgres, an UPDATE writes a whole new copy of the row. In 2016 Uber put the cost of that, write amplification, first on its list of reasons for moving from Postgres to MySQL.
- The counter that ran out Postgres transaction IDs are 32-bit. At Mailchimp's Mandrill, one shard hit the limit and the database stopped accepting writes. Email sending resumed about 40 hours later.