Hacker News new | ask | show | jobs
by gfody 855 days ago
> 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

1 comments

Yeah it doesn't make sense to pick something that's not a power of 2 unless you are packing it.
I guess that depends on how the index works.
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