> On Aug 11, 2020, at 09:37, Mark Phillips <mark.phillips@mophilly.com> 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
mostsignificant bits can cause significant cache hit problems on large indexes. 128 bit keys are usually overkill for
mostapplications, unless you need actual *global* uniqueness across more than a single database or installation; 64 bit
keysare usually sufficient.
UUIDs (and similar very large random keys) do have the advantage that they are somewhat self-secure: You can expose
themto outsiders without having to worry about other keys being guessable.
--
-- Christophe Pettus
xof@thebuild.com