On: My notes on Gitlab's Postgres schema design (2022)

[gfody]

> 1 quintillion is equal to 1000000000 billions

it is pretty wild that we generally choose between int32 and int64. we really ought to have a 5 byte integer type which would support cardinalities of ~1T

[klysm → gfody]

Yeah it doesn't make sense to pick something that's not a power of 2 unless you are packing it.

[postalrat → klysm]

I guess that depends on how the index works.

[gfody → klysm]

we usually work with some page size anyways, 64 5-byte ints fit nicely into 5 512-bit registers, and ~1T is a pretty flexible cardinality limit after ~2B