Actually, this is not such a unique idea:
https://instagram-engineering.com/sharding-ids-at-instagram-1cf5a71e5a5c
Thanks for the suggestion to split up the primary key into components. But even
going down this way, packing the components into one superstructure (composite
type) would be benefi
red as
integer, but becomes much more cumbersome with UUID, I guess.
Feladó: Rob Sargent
Elküldve: 2019. október 23., szerda 22:58
Címzett: Laiszner Tamás
Másolatot kap: pgsql-gene...@postgresql.org
Tárgy: Re: Composite type storage overhead
On Oct 23, 2
Hey there,
I am currently exploring the options to utilize 128-bit numeric primary keys.
One of the options I am looking at is to store them as composites of two 64-bit
integers.
The documentation page on composite types does not tell too much about the
internal storage, so I've made my own ex