Postgres Pro
Downloads
Home   >   mailing lists

Re: Uber migrated from Postgres to MySQL - Mailing list pgsql-general

From Jason Dusek
Subject Re: Uber migrated from Postgres to MySQL
Date
Msg-id CAO3NbwPmz-r1s_7xXH8zXU+hYfkEP7AuOcyESWMTWdX7ezgKmQ@mail.gmail.com
Whole thread Raw
In response to Uber migrated from Postgres to MySQL  (Guyren Howe <guyren@gmail.com>)
Responses Re: Uber migrated from Postgres to MySQL  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
List pgsql-general
Tree view
With regards to write amplification, it makes me think about about OIDs. Used to be, every row had an OID and that OID persisted across row versions.


Would reintroducing such a feature address some of Uber's concerns about multiple indexes? It could, and would do so without the implicit requirement of a foreign key; but it would also require a fast OID to CTID mapping.

On Tue, 26 Jul 2016 at 10:40 Guyren Howe <guyren@gmail.com> wrote:
Honestly, I've never heard of anyone doing that. But it sounds like they had good reasons.

https://eng.uber.com/mysql-migration/

Thoughts?

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: James Keener
Date:
Subject: Re: Uber migrated from Postgres to MySQL
Next
From: Jeff Janes
Date:
Subject: Re: Uber migrated from Postgres to MySQL