> On Aug 11, 2020, at 09:37, Mark Phillips <[email protected]> wrote:
>
> I posed the question on the chance things had evolved since 2012,
> specifically as it relates to postgres.
The essentials haven't changed. Keys (such as UUIDs, especially UUID v4) that
have most of their randomness in the most significant bits can cause
significant cache hit problems on large indexes. 128 bit keys are usually
overkill for most applications, unless you need actual *global* uniqueness
across more than a single database or installation; 64 bit keys are usually
sufficient.
UUIDs (and similar very large random keys) do have the advantage that they are
somewhat self-secure: You can expose them to outsiders without having to worry
about other keys being guessable.
--
-- Christophe Pettus
[email protected]
